I’m new to EasyMorph but already kind of like it
Before buying the product i would like to see if my challange descriped below can be handled.
I need to merge rows to compare two tables of rows. This is useful for comparing data from two different times. It is often used in situations where the source system of a data warehouse does not contain a date of last update.
The two tables of rows, a reference table (the old data) and a compare table (the new data), are merged. Only the last version of a row is passed to the next steps each time. The row is marked as follows:
- “identical” - The key was found in both tables and the values to compare are identical;
- “changed” - The key was found in both tables but one or more values is different;
- “new” - The key was not found in the reference table;
- “deleted” - The key was not found in the compare table.
When the rows are flagged as “identical” or “deleted”, the output row will be created based upon the “Reference rows origin” table. For “new” or “changed” rows, the output row will be created based upon the “Compare rows origin” table.