Squared design

[Didier]

1. No Data Cleansing tool
   1. Too slow and risk of configuration loss
   2. Use instead Multi Fields Formula Tool
2. Left join connected to main data stream and enrichment/filter/correction/Comparison on the right
   1. For easier reading of the workflow
3. Select after Input Data tool and before Output Data tool...
   1. If you don’t want to look for the missing column
   2. Only exception to remove intermediate column no longer required
4. ...and no use of the Select in Join tools which are fed only with required columns with the exceptions
   1. If enrichment: Deselect duplicate column
   2. If “filter”: Deselect all right columns
   3. If “Correction” set the name of the new column correcting and deselected column corrected
   4. If “Comparison” set the names of the column from both sides
5. Don’t use Unique in main data stream
   1. If you want to be in control of your date, use Summarize Tool