Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to work with columns that are not aligned

Sash
7 - Meteor

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

3 REPLIES 3
grossal
15 - Aurora
15 - Aurora

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

Aaron_Harter
11 - Bolide

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 #:

1.1.PNG

 

Sash
7 - Meteor

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

Labels