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??
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,
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.
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???
I posted the Generic Load here: http://community.qlik.com/message/389245#389245
I am closing this thread
Retrieving data ...