Hi community
I have a large set of data with columns not aligned. Please could I know how to align these . I have attached an example with just 2 sets of data.
I am on version 2018.4
Thank you
Solved! Go to Solution.
Hi @Sash,
will each team have it's on input file or sheet or will both teams have the data in one single sheet?
Best
Alex
Hi @Sash,
If your raw data is contained in one large table, you may be able to use the attached solution to identify the field headers for each team and Join them back based on the relative field position of the data points for each team #:
Thanks Aaron, I did manage to get it working which was ok in this instance but not 100% dynamic if I was to have a different dataset. So I will definitely check your solution to see how I can make the workflow dynamic. Thanks for taking the time