QQ - Engineering

14 Articles in this category

Print
Dark
Light

QQ - Engineering

14 Articles in this category

Dark
Light

QQ - How do I change a discrete string to continuous?

To change a discrete string to be continuous, use one of the following methods: Expression Builder Concat function (using JSON modfied in script editor) Expression Builder Concat Function Use the flag NOORD to force a continuous fiel...

QQ - How do I sort a table?

QQ - What is the difference between ICAST and WILDICAST?

This question is relevant for the following functions: Engineering | Functions | String | ICAST Engineering | Functions | String | WildICast Engineering | Functions | String | DCAST Engineering | Functions | String | WildDCAST The ICAST an...

QQ - How do I flag records that contain numeric data for a specific field?

I have a field that has a mix of numeric and string data in it - I can't work with the records that have the numeric data, so i want to flag them so that I can remove them from calculations - how do i do this? We can approach this problem using ...

QQ - How do I transform data loaded as string into a double?

Lat/long data loaded in format N 51.987878 E 00.654987 How do we transform this into usable Numeric fields? Use expression mid to trim the data and remove leading letters Use a programmed field to convert the data to a double or Use...

QQ - How do I create a join between a field that is continuous on one table and discrete on the other?

A: Use the flags option on function Concat to create a continuous keyfield How do i create a join between the following tables? Table1: BikeTripData 70,000,000 rows KeyField: Journey_ID Alphanumeric: S123E343 Continuous | String Ta...

QQ - How do I use the current date or time in expressions and calculations?

Use the Engineering | Expression Field Date functions Use today() function to calculate days since an event. Calculate days since [End Date]. Note: [End Date] is a date-time field, so the date() function is used to extract the date from the...

QQ - How do I get the name of the nearest city from a table of Geo Data?

Use the following actions: Load Geo Data (CreateTableFromFile: worldcities) Calculate the nearest city lookup (Engineering | Functions | Geo | Nearest : nearestcitylookup) NOTE: use Limiter #1 Create a self-join key (Engineering | Functions ...

QQ - How do I use Conditional and IF statements in DataJet?

There are 4 mechanisms for working with Conditional Statements in DataJet: Engineering | Functions | FLogic functions Engineering | Functions | LMath Engineering | Expression Field | Conditional functions Script | Editor | IF ELSE ENDIF...

QQ - How do I get detailed statistics for continuous data fields?

There are multiple ways of accessing statistical data in DataJet: Analytics | Statistics Analytics | Multi-field Statistics Database Tree | Right-Click | Statistics Analytics | Data Audit, select field (note: reduced basic stats for continuous...

QQ - How do I dynamically create a banded field in script?

Banded fields group numeric data into "bins" that have specified upper and lower limits. Various options are available for controlling banding through the Banded Field dialog. To create the kind of banded field that will dynamically calculate ...

QQ - How do I round up a decimal number to 1 decimal place?

To change the decimal precision of an existing double field (or to "Round-up" the number) use the Expression Builder:

QQ - How do I rename a table?

It is not possible to rename a table once it has been loaded as changing a table name has too many implications for scripts, reports and calculated fields. With that in mind, if it is still necessary to change the name of a table, use one of the f...

QQ - How do I cast between different data types?

Article In Progress... In general data should be loaded into a system so that field-data types are well matched, but this is not always possible. The following functional areas may require field-data types to be changed: Joins - there are...