Multiple Excel Reports with same header names and Synthetic Key

[#1]

I am creating a QlikView document and I am loading multiple excel files with the same report information ( ie name, id number, etc ) with most of the names being the same across the reports and its gonna lead to one hell of a synthetic key, and I am just wondering what would be the best way to deal with it? Concatenation perhaps

[oknotsen · Accepted solution]

If all XLS are the same table with maybe a few columns different, there are two possible solutions:

If you need to keep the columns that don't exist in all tables, use concatenate.

If you do not need the columns, don't load them (or comment them in your load script) so all tables have exactly the same columns and the tables will automatically concatenate.

[#3]

Thank you very much