Hi All,
I'm pretty sure similar questions have been asked before somewhere; however either I'm still too new to Alteryx or just incapable of understanding some of the discussion so I haven't yet to succeed here even I tried to mimic some of the discussions.
I have some sample files here to illustrate the task at hand:
- A handful of month-end file to combine all data into Alteryx workflow for further analysis
- All the report run date is on the file name (as sample files)
- Over the time some more elements (fields) may be introduced so not all file have the same column counts
- Over the time certain field name may have a different convention (or just because different people did the excel work and called it differently, in this sample case the first column can be either called library card number, account number.. etc it all refers to the same thing)
- Sometimes even same filed name may have slightly different schema, some office would use numbers for account number while some may use text.
The ideal result file is to conbime everything into one big sheet/ table, with a new column to refer to the report date (from the file name). Since the data points were increasing over time, it's ok to have certain elements empty for those prior months.
Any chance someone may be able to help me out please?
Thanks in advance!
