Hi - I am a new Alteryx user so forgive me if this is a stupid question. I typically do these things in excel but I am wanting to use Alteryx to get this done. I have two (excel) spreadsheets:
1. Customer Data ( individual customer data )
2. Column ID ( identifies the column from Customer data that applies to a particular category )
The problem is: each time i receive the Customer Data sheet, I get different column headers. The headers vary by source. This is why I am using another spreadsheet to identify the column (Column ID).
Now for my question: How do I use this Column ID sheet to pull in the Customer Data under the new headers? I am open to all suggestions.
