topic Question - loading data (excel) with dynamic columns. in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Question-loading-data-excel-with-dynamic-columns/m-p/1076923#M1701 <HTML><HEAD></HEAD><BODY><P>Hi I want to load excelfiles (in batches) - and the format it not always consistent, is there a simple way in the loadscript</P><P>to check if a column exists or not - and handle that by assigning a blank value, a static, or a some other value from another column.</P><P></P><P>Thanks for any comment <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Tue, 15 Mar 2016 13:20:10 GMT 2016-03-15T13:20:10Z Question - loading data (excel) with dynamic columns. https://community.qlik.com/t5/Connectivity-Data-Prep/Question-loading-data-excel-with-dynamic-columns/m-p/1076923#M1701 <HTML><HEAD></HEAD><BODY><P>Hi I want to load excelfiles (in batches) - and the format it not always consistent, is there a simple way in the loadscript</P><P>to check if a column exists or not - and handle that by assigning a blank value, a static, or a some other value from another column.</P><P></P><P>Thanks for any comment <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Tue, 15 Mar 2016 13:20:10 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Question-loading-data-excel-with-dynamic-columns/m-p/1076923#M1701 2016-03-15T13:20:10Z Re: Question - loading data (excel) with dynamic columns. https://community.qlik.com/t5/Connectivity-Data-Prep/Question-loading-data-excel-with-dynamic-columns/m-p/1076924#M1702 <HTML><HEAD></HEAD><BODY><P>Have a look here: <A href="https://community.qlik.com/message/869815">Re: Load multiple files with some missing some colums</A></P><P></P><P>- Marcus</P></BODY></HTML> Tue, 15 Mar 2016 13:45:00 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Question-loading-data-excel-with-dynamic-columns/m-p/1076924#M1702 marcus_sommer 2016-03-15T13:45:00Z