topic Re: Multiple Excel Reports with same header names and Synthetic Key in Qlik Learning Discussions https://community.qlik.com/t5/Qlik-Learning-Discussions/Multiple-Excel-Reports-with-same-header-names-and-Synthetic-Key/m-p/813611#M2722 <HTML><HEAD></HEAD><BODY><P>Thank you very much</P></BODY></HTML> Fri, 06 Mar 2015 14:15:33 GMT 2015-03-06T14:15:33Z Multiple Excel Reports with same header names and Synthetic Key https://community.qlik.com/t5/Qlik-Learning-Discussions/Multiple-Excel-Reports-with-same-header-names-and-Synthetic-Key/m-p/813609#M2720 <HTML><HEAD></HEAD><BODY><P>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</P></BODY></HTML> Mon, 02 Mar 2015 11:20:40 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Multiple-Excel-Reports-with-same-header-names-and-Synthetic-Key/m-p/813609#M2720 2015-03-02T11:20:40Z Re: Multiple Excel Reports with same header names and Synthetic Key https://community.qlik.com/t5/Qlik-Learning-Discussions/Multiple-Excel-Reports-with-same-header-names-and-Synthetic-Key/m-p/813610#M2721 <HTML><HEAD></HEAD><BODY><P>If all XLS are the same table with maybe a few columns different, there are two possible solutions:</P><P></P><P>If you need to keep the columns that don't exist in all tables, use concatenate.</P><P>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.</P></BODY></HTML> Mon, 02 Mar 2015 20:58:36 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Multiple-Excel-Reports-with-same-header-names-and-Synthetic-Key/m-p/813610#M2721 oknotsen 2015-03-02T20:58:36Z Re: Multiple Excel Reports with same header names and Synthetic Key https://community.qlik.com/t5/Qlik-Learning-Discussions/Multiple-Excel-Reports-with-same-header-names-and-Synthetic-Key/m-p/813611#M2722 <HTML><HEAD></HEAD><BODY><P>Thank you very much</P></BODY></HTML> Fri, 06 Mar 2015 14:15:33 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/Multiple-Excel-Reports-with-same-header-names-and-Synthetic-Key/m-p/813611#M2722 2015-03-06T14:15:33Z