topic Re: Can a script be developed to join a table where the the information needs to be transposed upon loading into Qlikview in QlikView https://community.qlik.com/t5/QlikView/Can-a-script-be-developed-to-join-a-table-where-the-the/m-p/791434#M667901 <HTML><HEAD></HEAD><BODY><P>Not an avid developer, but learning.&nbsp; I am not seeing how to "open" the wizard in the script editor...not seeing where the spreadsheets option is?</P></BODY></HTML> Fri, 21 Nov 2014 15:49:44 GMT Anonymous 2014-11-21T15:49:44Z Can a script be developed to join a table where the the information needs to be transposed upon loading into Qlikview https://community.qlik.com/t5/QlikView/Can-a-script-be-developed-to-join-a-table-where-the-the/m-p/791431#M667898 <HTML><HEAD></HEAD><BODY><P>I have a spreadsheet that I would like to join in Qlikview where part of the rows I want to transpose upon loading.</P></BODY></HTML> Thu, 20 Nov 2014 20:12:38 GMT https://community.qlik.com/t5/QlikView/Can-a-script-be-developed-to-join-a-table-where-the-the/m-p/791431#M667898 Anonymous 2014-11-20T20:12:38Z Re: Can a script be developed to join a table where the the information needs to be transposed upon loading into Qlikview https://community.qlik.com/t5/QlikView/Can-a-script-be-developed-to-join-a-table-where-the-the/m-p/791432#M667899 <HTML><HEAD></HEAD><BODY><P>Hi Todd,</P><P></P><P>sure. Transposing is a function you have in the LOAD wizard in QlikView.&nbsp; I use it quite often when the data in Excel that I want to load is in a Crosstab-like structure - it's a bit more complex than doing a crosstab_load, but I think it is more powerful.</P><P>Just open the wizard in the script_editor (by clicking on "spreadsheets") and on the second screen, enter the editing_mode. Transposing is an option on the "rotate" tab.</P><P>HTH</P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Thu, 20 Nov 2014 20:33:59 GMT https://community.qlik.com/t5/QlikView/Can-a-script-be-developed-to-join-a-table-where-the-the/m-p/791432#M667899 datanibbler 2014-11-20T20:33:59Z Re: Can a script be developed to join a table where the the information needs to be transposed upon loading into Qlikview https://community.qlik.com/t5/QlikView/Can-a-script-be-developed-to-join-a-table-where-the-the/m-p/791433#M667900 <HTML><HEAD></HEAD><BODY><P>Did you try CrossTable?</P><P></P><P>Select Excel File you need from Table files in Script and then use file wizard for the cross table.</P><P></P><P>Yes, forgot that option, as <A href="https://community.qlik.com/qlik-users/115174">DataNibbler</A> said, Try Rotate/Transpose option from Enable Transformation Step in file wizard of the script.</P></BODY></HTML> Thu, 20 Nov 2014 20:35:11 GMT https://community.qlik.com/t5/QlikView/Can-a-script-be-developed-to-join-a-table-where-the-the/m-p/791433#M667900 2014-11-20T20:35:11Z Re: Can a script be developed to join a table where the the information needs to be transposed upon loading into Qlikview https://community.qlik.com/t5/QlikView/Can-a-script-be-developed-to-join-a-table-where-the-the/m-p/791434#M667901 <HTML><HEAD></HEAD><BODY><P>Not an avid developer, but learning.&nbsp; I am not seeing how to "open" the wizard in the script editor...not seeing where the spreadsheets option is?</P></BODY></HTML> Fri, 21 Nov 2014 15:49:44 GMT https://community.qlik.com/t5/QlikView/Can-a-script-be-developed-to-join-a-table-where-the-the/m-p/791434#M667901 Anonymous 2014-11-21T15:49:44Z Re: Can a script be developed to join a table where the the information needs to be transposed upon loading into Qlikview https://community.qlik.com/t5/QlikView/Can-a-script-be-developed-to-join-a-table-where-the-the/m-p/791435#M667903 <HTML><HEAD></HEAD><BODY><P>There is a button in the script_editor, the topmost one (lower half of the screen).</P><P>My version is German, so I'm not sure what it will be labeled, but that's the one.</P><P>Once it opens, you just navigate to the file you want to load and QlikView should recognize it.</P></BODY></HTML> Fri, 21 Nov 2014 15:52:41 GMT https://community.qlik.com/t5/QlikView/Can-a-script-be-developed-to-join-a-table-where-the-the/m-p/791435#M667903 datanibbler 2014-11-21T15:52:41Z Re: Can a script be developed to join a table where the the information needs to be transposed upon loading into Qlikview https://community.qlik.com/t5/QlikView/Can-a-script-be-developed-to-join-a-table-where-the-the/m-p/791436#M667905 <HTML><HEAD></HEAD><BODY><P>Thanks kindly.&nbsp; Makes sense now on the navigation to transpose.</P></BODY></HTML> Fri, 21 Nov 2014 15:54:48 GMT https://community.qlik.com/t5/QlikView/Can-a-script-be-developed-to-join-a-table-where-the-the/m-p/791436#M667905 Anonymous 2014-11-21T15:54:48Z