topic Re: Working With Source Data With Multiple Data in QlikView https://community.qlik.com/t5/QlikView/Working-With-Source-Data-With-Multiple-Data/m-p/1295902#M833285 <HTML><HEAD></HEAD><BODY><P>I am failing to follow. please may you assist.&nbsp; The other challenge I have is the number of columns on the 3 levels of headers differ for each section which is different from a normal pivot. </P></BODY></HTML> Sat, 03 Jun 2017 15:53:57 GMT ngrunoz 2017-06-03T15:53:57Z Working With Source Data With Multiple Data https://community.qlik.com/t5/QlikView/Working-With-Source-Data-With-Multiple-Data/m-p/1295898#M833281 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have source data in excel that has got multiple header which I want to extract. How best can I transform it. Find attached. </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Working-With-Source-Data-With-Multiple-Data/m-p/1295898#M833281 ngrunoz 2020-11-25T16:16:04Z Re: Working With Source Data With Multiple Data https://community.qlik.com/t5/QlikView/Working-With-Source-Data-With-Multiple-Data/m-p/1295899#M833282 <HTML><HEAD></HEAD><BODY><P>You have to normalize that table usign <A href="https://help.qlik.com/en-US/sense/3.1/Subsystems/Hub/Content/Scripting/ScriptPrefixes/crosstable.htm">crosstable function</A></P></BODY></HTML> Thu, 01 Jun 2017 11:55:22 GMT https://community.qlik.com/t5/QlikView/Working-With-Source-Data-With-Multiple-Data/m-p/1295899#M833282 micheledenardi 2017-06-01T11:55:22Z Re: Working With Source Data With Multiple Data https://community.qlik.com/t5/QlikView/Working-With-Source-Data-With-Multiple-Data/m-p/1295900#M833283 <HTML><HEAD></HEAD><BODY><P>I think we can try that way if possible</P></BODY></HTML> Thu, 01 Jun 2017 13:26:51 GMT https://community.qlik.com/t5/QlikView/Working-With-Source-Data-With-Multiple-Data/m-p/1295900#M833283 ngrunoz 2017-06-01T13:26:51Z Re: Working With Source Data With Multiple Data https://community.qlik.com/t5/QlikView/Working-With-Source-Data-With-Multiple-Data/m-p/1295901#M833284 <HTML><HEAD></HEAD><BODY><P>To handle multiple header rows, see here for inspiration: <A href="https://community.qlik.com/docs/DOC-4527">multi_header_pivot_import.qvw</A></P></BODY></HTML> Thu, 01 Jun 2017 14:11:43 GMT https://community.qlik.com/t5/QlikView/Working-With-Source-Data-With-Multiple-Data/m-p/1295901#M833284 Peter_Cammaert 2017-06-01T14:11:43Z Re: Working With Source Data With Multiple Data https://community.qlik.com/t5/QlikView/Working-With-Source-Data-With-Multiple-Data/m-p/1295902#M833285 <HTML><HEAD></HEAD><BODY><P>I am failing to follow. please may you assist.&nbsp; The other challenge I have is the number of columns on the 3 levels of headers differ for each section which is different from a normal pivot. </P></BODY></HTML> Sat, 03 Jun 2017 15:53:57 GMT https://community.qlik.com/t5/QlikView/Working-With-Source-Data-With-Multiple-Data/m-p/1295902#M833285 ngrunoz 2017-06-03T15:53:57Z