topic Re: Row wise data to coulmn data in QlikView

Row wise data to coulmn data

Anonymous — Tue, 03 Sep 2013 05:52:36 GMT

Hi all,

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:

Key	Value 1	Value 2	Value 3
12	ABC	SYZ	93
13	asd	gdfg	63

Please help me out to get this result at script level.

Thanks

Aashish

Tue, 03 Sep 2013 10:45:24 GMT

Hello Aashish,

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)

Source:

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

RESIDENT Source;

Please let me know, if it was helpful

Thanks,

ASINGH

ariel_klien — Wed, 04 Sep 2013 09:41:22 GMT

don't forget to drop the source table....