Discussion Board for collaboration on QlikView Scripting.
At the script level i need to convert row wise data to coulmn wise.
My source data is
and i need to get output like:
Please help me out to get this result at script level.
We can achieve this by 2 ways, One with Generic Load and Other with Crosstable.
Please find below example with Generic Load : (Remember you need to have that IDcount column)
LOAD * INLINE [
Key, Value, IDcount
12, ABC, 1
12, SYZ, 2
12, 93, 3
13, asd, 1
13, gdfg, 2
13, 63, 3
GENERIC LOAD Key, 'Value' & IDcount, Value
Please let me know, if it was helpful
don't forget to drop the source table....