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

[stevemarkovick]

When I design workflows in Alteryx, I’ve found that keeping layouts clean and modular makes collaboration easier. Squared design principles—aligning tools neatly, grouping related steps, and labeling clearly—help me troubleshoot faster later. It might feel cosmetic at first, but organized design reduces errors and speeds up onboarding when others review the workflow. A tidy canvas really improves long-term efficiency.