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:
| 
