We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Configure Input too to ignore data headers

hendricksk
7 - Meteor

Each month I run a workflow that grabs the same data file, however each month I save over the existing file. My issue is that the files change the months, therefore I get errors each month and have to re-point the columns. For example, below next month the file will have August, September, and October. 

Products July August September
Apples      3         4        5

 

 

Is there a way to get the Input tool to ignore the headers so it does error next month when the headers are different?

2 REPLIES 2
hendricksk
7 - Meteor

I think I figured it out. I used the Dynamic Rename tool. If anyone has a better suggestion, please let me know.

alexnajm
18 - Pollux
18 - Pollux

Depends on your ultimate goal for the data, but generally yes a Dynamic Rename tool can work well

Labels
Top Solution Authors