topic Re: restructuring data in the load in QlikView https://community.qlik.com/t5/QlikView/restructuring-data-in-the-load/m-p/576715#M1100951 <HTML><HEAD></HEAD><BODY><P>You may use crosstable, look for it in help</P></BODY></HTML> Tue, 15 Apr 2014 09:24:37 GMT alexandros17 2014-04-15T09:24:37Z restructuring data in the load https://community.qlik.com/t5/QlikView/restructuring-data-in-the-load/m-p/576714#M1100950 <HTML><HEAD></HEAD><BODY><P>below is a sample of data and how it is arranged however is it possible to rearrange it in the load sequence so my collumns are</P><P></P><P>Time, Type, 'MainCarriagewayDataFilteringOutput.site2.o',&nbsp; 'MainCarriagewayDataFilteringOutput.site2.q'</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Value</P><P></P><P>hopefully that makes sense what im after is a collumn for each Name and the corresponding value at that time for that Name.</P><P></P><P>thanks for any help</P><TABLE border="0" cellpadding="0" cellspacing="0"><TBODY><TR><TD class="xl63" height="19" style="border: 0px solid black;" width="105">'Time'</TD><TD class="xl63" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;" width="78"> 'Type'</TD><TD class="xl63" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;" width="330"> 'Name'</TD><TD class="xl63" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;" width="106"> 'Value'</TD></TR><TR><TD class="xl63" height="19" style="border: 0px solid black;" width="105">00:00</TD><TD class="xl63" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;" width="78"></TD><TD class="xl63" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;" width="330">'MainCarriagewayDataFilteringOutput.site2.o'</TD><TD class="xl63" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;" width="106"><P>1</P></TD></TR><TR><TD class="xl63" height="19" style="border: 0px solid black;" width="105">00:00</TD><TD class="xl63" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;" width="78"></TD><TD class="xl63" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;" width="330">'MainCarriagewayDataFilteringOutput.site2.q'</TD><TD class="xl63" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;" width="106">2</TD></TR><TR><TD class="xl63" height="19" style="border: 0px solid black;" width="105">00:01</TD><TD class="xl63" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;" width="78"></TD><TD class="xl63" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;" width="330">'MainCarriagewayDataFilteringOutput.site2.o'</TD><TD class="xl63" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;" width="106">3</TD></TR><TR><TD class="xl63" height="19" style="border: 0px solid black;" width="105">00:01</TD><TD class="xl63" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;" width="78"></TD><TD class="xl63" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;" width="330">'MainCarriagewayDataFilteringOutput.site2.q'</TD><TD class="xl63" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;" width="106">4</TD></TR><TR><TD class="xl63" height="19" style="border: 0px solid black;" width="105">00:02</TD><TD class="xl63" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;" width="78"></TD><TD class="xl63" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;" width="330">'MainCarriagewayDataFilteringOutput.site2.o'</TD><TD class="xl63" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;" width="106"></TD></TR><TR><TD class="xl63" height="19" style="border: 0px solid black;" width="105">00:02</TD><TD class="xl63" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;" width="78"></TD><TD class="xl63" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;" width="330">'MainCarriagewayDataFilteringOutput.site2.q'</TD><TD class="xl63" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;" width="106"></TD></TR><TR><TD class="xl63" height="19" style="border: 0px solid black;" width="105"></TD><TD class="xl63" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;" width="78"></TD><TD class="xl63" style="border-width: 0px 0px 0px medium; border-style: solid solid solid none; border-color: black black black currentColor;" width="330">'MainCarriagewayDataFilteringOutput.site2.o'</TD></TR></TBODY></TABLE></BODY></HTML> Tue, 15 Apr 2014 09:15:03 GMT https://community.qlik.com/t5/QlikView/restructuring-data-in-the-load/m-p/576714#M1100950 samuel_brierley 2014-04-15T09:15:03Z Re: restructuring data in the load https://community.qlik.com/t5/QlikView/restructuring-data-in-the-load/m-p/576715#M1100951 <HTML><HEAD></HEAD><BODY><P>You may use crosstable, look for it in help</P></BODY></HTML> Tue, 15 Apr 2014 09:24:37 GMT https://community.qlik.com/t5/QlikView/restructuring-data-in-the-load/m-p/576715#M1100951 alexandros17 2014-04-15T09:24:37Z