Discussion Board for collaboration on QlikView Scripting.
This might be too easy to put on the forum but I'm in a bit of a rush. Would be grateful for a helping hand.
I've got a table such as this:
I need to transform this table at load time to look like this:
Here's the inline code for the input table:
Load * inline [
Thank you, guys!
This should work:
Table1Final:CrossTable (Type, Value)Load * inline [Name,A,B,CJack,50,100,150Jill,25,50,75];
CrossTable (Type, Value)
The resulting table should have three fields, Name, Type and Value, and values in rows transposed.
Hope that helps.