TARGET Coder

Coder provides data de-normalization by joining data from master and reference tables according to user-defined relations and data moving rules.

Coder also supports data removal and extraction from the master table by setting relations with reference tables (In the future, this functionality will be separated into an individual data-extracting tool).

Automation Procedure

Join data from the Input Data Source with data from one or several Reference Data Sources according to user-defined relations and save resulting table in an Output Data Source.

Variables

Control Variables

 

Start (Input var.)

Initiates the procedure.

Finished (Output var.)

Information in reference to finishing the procedure.

Data

 

Input Data Source

Data table or view from an arbitrary database.

Reference Data Sources

Data tables or views from arbitrary databases.

Output Data Source

Output data table that can be saved to an arbitrary database.

 

Features

·         Advanced options such as “Blank if not matched,” “Blank if matched,” “Replace empty only,” “Add missing to reference.”

·         Full synchronization of UI element selection.

·         Complete automated self-reporting.


Screenshots

Sample screenshot of Coder in Coding mode:



Sample screenshot of Coder in Super-Duper mode with the Add Missing from Reference option:



Sample screenshot of Coder in Super-Duper mode with the Remove by Reference option:



Sample screenshot of Coder in Union/Join Mode:




Comments