Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Multiple Excel Reports with same header names and Synthetic Key

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

Tags (2)
1 Solution

Accepted Solutions
oknotsen
Honored Contributor III

Re: Multiple Excel Reports with same header names and Synthetic Key

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.

May you live in interesting times!

View solution in original post

2 Replies
oknotsen
Honored Contributor III

Re: Multiple Excel Reports with same header names and Synthetic Key

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.

May you live in interesting times!

View solution in original post

Not applicable

Re: Multiple Excel Reports with same header names and Synthetic Key

Thank you very much