Engineering

What is Engineering Data? Data engineering is the process of transforming data. It involves creating and maintaining processes to make data usable for analysis and decision-making. There are multiple approaches for engineering - or transforming ...

Overview Aggregating combines all records for each unique join-key on a foreign table in some manner, and creates that entity as a field on the primary side of the join. Consider the relationship above, each customer may have multiple tran...

Overview When a numeric field is continuous or has too many unique values to be usefully analysed visually we can create a new banded field. Banded fields are created form a set of value ranges and a label that is associated with each range....

Overview Copies a field from a primary (one-side)  table to foreign (many-side) table Accessed through the Engineering menu. Select the source table and field and the target table from the combo boxes. Apply a filter if required...

Overview Copies a field from a foreign (many-side) table to a primary (one-side) table. Accessed through the Engineering menu. Foreign Table: The table to copy FROM Primary Table: The table to copy TO Copy : The field to copy Ke...

Overview Create multiple flag fields from multiple discrete values of a given field. Setup Select source table then field Or drop a field onto the fields combo Or drop a field onto the grid The grid will fill with the unique values o...

Overview Accessed through Main Menu - Decode - Custom Custom decode creates a new field by mapping each unique (distinct) value of the source field to a new value in the destination. At its simplest, this procedure can be used to trans...

Overview Unlike a regular decode, which will map a given categorical value in the source fields onto a new categorial value in the target field. A Wild Decode will map the source categorical value on the Decode for the first bin that it match...

The Import List dialog allows a dataset to be imported from a list of values within a file. A dataset of type "EMBEDDED" is created when a list is imported. { "method": "SaveDataSet", "name": "Top Spenders", "dataSet": { "logic"...

In order to perform cross-table operations, it is first necessary to join the tables.    The Joins dialog is opened via Engineering | Joins. Joins can be also created by dropping the primary key field onto the foreign ke...

A key table is a table that is generated from another table, and that has one record for every unique value in a source field on the original table.  The purpose of a key table is to allow more complex analysis to be performed around that fi...

Overview