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?
I think I figured it out. I used the Dynamic Rename tool. If anyone has a better suggestion, please let me know.
Depends on your ultimate goal for the data, but generally yes a Dynamic Rename tool can work well