https://community.qlik.com/t5/QlikView/Reverse-Generic-Load/m-p/1574715#M442419 <P>Yes that should work. I forgot to mention that it should account for additional columns added to the right. Is there a way for additional columns added to the right in the future to be loaded automatically?</P> Tue, 30 Apr 2019 00:30:50 GMT Crprtslv 2019-04-30T00:30:50Z https://community.qlik.com/t5/QlikView/Reverse-Generic-Load/m-p/1574707#M442417 <P>Greetings,</P><P>I would like to set up my data that is like the Input to be in the format of the Output. How can this be achieved?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2019_04_29_13_47_14_54157_Generic_transformation4.png_Windows_Photo_Viewer.png" style="width: 671px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/11134iF6E2DF93352618FE/image-size/large?v=v2&amp;px=999" role="button" title="2019_04_29_13_47_14_54157_Generic_transformation4.png_Windows_Photo_Viewer.png" alt="2019_04_29_13_47_14_54157_Generic_transformation4.png_Windows_Photo_Viewer.png" /></span></P> Mon, 29 Apr 2019 22:13:11 GMT https://community.qlik.com/t5/QlikView/Reverse-Generic-Load/m-p/1574707#M442417 Crprtslv 2019-04-29T22:13:11Z https://community.qlik.com/t5/QlikView/Reverse-Generic-Load/m-p/1574710#M442418 <P>I think you are looking for the&nbsp;<A href="https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/ScriptPrefixes/crosstable.htm" target="_self">crosstable</A>&nbsp;function.</P> Mon, 29 Apr 2019 22:43:32 GMT https://community.qlik.com/t5/QlikView/Reverse-Generic-Load/m-p/1574710#M442418 jwjackso 2019-04-29T22:43:32Z https://community.qlik.com/t5/QlikView/Reverse-Generic-Load/m-p/1574715#M442419 <P>Yes that should work. I forgot to mention that it should account for additional columns added to the right. Is there a way for additional columns added to the right in the future to be loaded automatically?</P> Tue, 30 Apr 2019 00:30:50 GMT https://community.qlik.com/t5/QlikView/Reverse-Generic-Load/m-p/1574715#M442419 Crprtslv 2019-04-30T00:30:50Z https://community.qlik.com/t5/QlikView/Reverse-Generic-Load/m-p/1574765#M442432 <P>If they are just additional data, then use&nbsp; a LOAD* to collect all fields:</P><P><FONT face="courier new,courier">CrosssTable(label, value, 1)</FONT><BR /><FONT face="courier new,courier">Load *</FONT><BR /><FONT face="courier new,courier">From ...</FONT></P><P>If they are new attributes, then adjust the load so they are listed first and amend the crosstable attribute count:</P><P><FONT face="courier new,courier">CrosssTable(label, value, <EM><STRONG>2</STRONG></EM>)</FONT><BR /><FONT face="courier new,courier">Load Key, <STRONG><EM>newAttribute</EM></STRONG>, Color, ....</FONT><BR /><FONT face="courier new,courier">From ...</FONT></P> Tue, 30 Apr 2019 05:57:34 GMT https://community.qlik.com/t5/QlikView/Reverse-Generic-Load/m-p/1574765#M442432 jonathandienst 2019-04-30T05:57:34Z