topic Transposing SQL fields, is it possible? in QlikView https://community.qlik.com/t5/QlikView/Transposing-SQL-fields-is-it-possible/m-p/500257#M1235228 <HTML><HEAD></HEAD><BODY><P>Hey guys, I have one field that I need it to be transposed, and it's a SQL from a database ODBC... Is it possible? How do I do that??</P></BODY></HTML> Mon, 26 Jan 2026 16:26:21 GMT 2026-01-26T16:26:21Z Transposing SQL fields, is it possible? https://community.qlik.com/t5/QlikView/Transposing-SQL-fields-is-it-possible/m-p/500257#M1235228 <HTML><HEAD></HEAD><BODY><P>Hey guys, I have one field that I need it to be transposed, and it's a SQL from a database ODBC... Is it possible? How do I do that??</P></BODY></HTML> Mon, 26 Jan 2026 16:26:21 GMT https://community.qlik.com/t5/QlikView/Transposing-SQL-fields-is-it-possible/m-p/500257#M1235228 2026-01-26T16:26:21Z Re: Transposing SQL fields, is it possible? https://community.qlik.com/t5/QlikView/Transposing-SQL-fields-is-it-possible/m-p/500258#M1235232 <HTML><HEAD></HEAD><BODY><P>Hi Julio,</P><P></P><P>Use the cross table syntex in Qlikview script, if you wanna do it in Qlikview script</P><P><SPAN class="Bold"><SPAN style="background-color: #3399ff; color: #ffffff;">crosstable</SPAN> (</SPAN><SPAN class="Italic">attribute field name, data field name [ , n ] <SPAN class="Bold">)</SPAN> ( loadstatement | selectstatement )</SPAN> </P><P></P><P>Hope this helps,</P><P>Anosh</P></BODY></HTML> Mon, 09 Sep 2013 20:40:42 GMT https://community.qlik.com/t5/QlikView/Transposing-SQL-fields-is-it-possible/m-p/500258#M1235232 2013-09-09T20:40:42Z Re: Transposing SQL fields, is it possible? https://community.qlik.com/t5/QlikView/Transposing-SQL-fields-is-it-possible/m-p/500259#M1235234 <HTML><HEAD></HEAD><BODY><P>Hi Julio,</P><P></P><P>I rather think you will need a generic load instead of crosstable. If you upload an example I can show a script snipped how to do.</P><P></P><P>- Ralf</P></BODY></HTML> Mon, 09 Sep 2013 20:57:58 GMT https://community.qlik.com/t5/QlikView/Transposing-SQL-fields-is-it-possible/m-p/500259#M1235234 rbecher 2013-09-09T20:57:58Z Re: Transposing SQL fields, is it possible? https://community.qlik.com/t5/QlikView/Transposing-SQL-fields-is-it-possible/m-p/500260#M1235236 <HTML><HEAD></HEAD><BODY><P>Hey Ralf, I would like to do here <A href="https://community.qlik.com/thread/91117">Problem with map and getting the latitude/longitude</A></P><P></P><P>try to transpose "meta_key" e "meta_value", will that work, perhaps, to solve my problem??? </P></BODY></HTML> Mon, 09 Sep 2013 23:46:15 GMT https://community.qlik.com/t5/QlikView/Transposing-SQL-fields-is-it-possible/m-p/500260#M1235236 2013-09-09T23:46:15Z Re: Transposing SQL fields, is it possible? https://community.qlik.com/t5/QlikView/Transposing-SQL-fields-is-it-possible/m-p/500261#M1235238 <HTML><HEAD></HEAD><BODY><P>I posted the Generic Load here: <A _jive_internal="true" class="loading" href="https://community.qlik.com/message/389245#389245" title="http://community.qlik.com/message/389245#389245">http://community.qlik.com/message/389245#389245</A></P></BODY></HTML> Tue, 10 Sep 2013 06:49:47 GMT https://community.qlik.com/t5/QlikView/Transposing-SQL-fields-is-it-possible/m-p/500261#M1235238 rbecher 2013-09-10T06:49:47Z Re: Transposing SQL fields, is it possible? https://community.qlik.com/t5/QlikView/Transposing-SQL-fields-is-it-possible/m-p/500262#M1235240 <HTML><HEAD></HEAD><BODY><P>I am closing this thread</P></BODY></HTML> Tue, 10 Sep 2013 11:42:42 GMT https://community.qlik.com/t5/QlikView/Transposing-SQL-fields-is-it-possible/m-p/500262#M1235240 2013-09-10T11:42:42Z