topic Re: Need help to load data using cross tables in QlikView https://community.qlik.com/t5/QlikView/Need-help-to-load-data-using-cross-tables/m-p/406365#M1165662 <HTML><HEAD></HEAD><BODY><P>I am not sure that you need a cross table.&nbsp; I would do this in two stages.&nbsp; I would load the sheet starting with the headers on row 3 (and all the subsequent rows).&nbsp;&nbsp; Then I would do another load of the sheet preceeded by "join" to apply the date fields to each row you previously loaded.</P></BODY></HTML> Thu, 13 Sep 2012 19:13:46 GMT Anonymous 2012-09-13T19:13:46Z Need help to load data using cross tables https://community.qlik.com/t5/QlikView/Need-help-to-load-data-using-cross-tables/m-p/406364#M1165661 <HTML><HEAD></HEAD><BODY><P>hi friends,</P><P></P><P></P><P>can anybody helpmeout in resolving this issue</P><P>Issue is</P><P></P><P>I have a sample data as shown in figure which has two headers in the same source sheet as shown below</P><P><IMG __jive_id="21805" class="jive-image" alt="1.jpg" src="https://community.qlik.com/legacyfs/online/21805_1.jpg" /></P><P>now i want the result in qlikview as below.. I want the last record to be updated for the time being and also let me know what i need to do if i would like to list all the records from 1 to 6 with the same order,target and delivery date populated in their corresponding columns instead of only the last record which is my current requirement now as displayed below in the image.</P><P><IMG __jive_id="21812" class="jive-image-thumbnail jive-image" onclick="" alt="2.jpg" src="https://community.qlik.com/legacyfs/online/21812_2.jpg" width="450" /></P><P></P><P>I thouth that a cross table can be used to get the above result ,im not sure ,kindly helpme out in getting this resolved.</P><P></P><P>Kind Regards</P><P>Anand.</P></BODY></HTML> Thu, 13 Sep 2012 19:00:24 GMT https://community.qlik.com/t5/QlikView/Need-help-to-load-data-using-cross-tables/m-p/406364#M1165661 2012-09-13T19:00:24Z Re: Need help to load data using cross tables https://community.qlik.com/t5/QlikView/Need-help-to-load-data-using-cross-tables/m-p/406365#M1165662 <HTML><HEAD></HEAD><BODY><P>I am not sure that you need a cross table.&nbsp; I would do this in two stages.&nbsp; I would load the sheet starting with the headers on row 3 (and all the subsequent rows).&nbsp;&nbsp; Then I would do another load of the sheet preceeded by "join" to apply the date fields to each row you previously loaded.</P></BODY></HTML> Thu, 13 Sep 2012 19:13:46 GMT https://community.qlik.com/t5/QlikView/Need-help-to-load-data-using-cross-tables/m-p/406365#M1165662 Anonymous 2012-09-13T19:13:46Z