Transposing SQL fields, is it possible?

[#1]

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??

[#2]

Hi Julio,

Use the cross table syntex in Qlikview script, if you wanna do it in Qlikview script

crosstable (attribute field name, data field name [ , n ] ) ( loadstatement | selectstatement )

Hope this helps,

Anosh

[rbecher]

Hi Julio,

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.

- Ralf

[#4]

Hey Ralf, I would like to do here Problem with map and getting the latitude/longitude

try to transpose "meta_key" e "meta_value", will that work, perhaps, to solve my problem???

[rbecher · Accepted solution]

I posted the Generic Load here: http://community.qlik.com/message/389245#389245

[#6]

I am closing this thread