Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Row wise data to coulmn data

Hi all,

At the script level i need to convert row wise data to coulmn wise.

My source data is

KeyIDValue
1245ABC
1246SYZ
124793
1345asd
1346gdfg
134763

and i need to get output like:

KeyValue 1Value 2Value 3
12ABCSYZ93
13asdgdfg63

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

Thanks

Aashish

2 Replies
Highlighted
Not applicable

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

Highlighted
Specialist
Specialist

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