In the image below the 3 selects on the left are from 3 data sources Im trying to align across 7 dimensions via data cleansing, filling nulls etc. The 7 select/uniques for each dimensions allow me to see inconsistencies (eg. one data source may have 'LATAM' as a region, while another has 'Latin America'). This works fine but now I also want apply the 7 select/uniques to the 3 sources individually. I selected this whole section and converted to macro but when it turns into the macro symbol there's a couple of issues 1) the macro symbol has no output so the workflow just ends which I dont want 2) the output is no longer the unique items of the 7 dimensions lined up but just looks like one of the unselected data sources instead.
What am I doing wrong? Once again the objective is to take the workflow below from the union to the multi-join, save as a macero and apply to the 3 selects on the left individually.
Thanks
