Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
aashish591
New Contributor II

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
Not applicable

Re: Row wise data to coulmn data

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
Valued Contributor

Re: Row wise data to coulmn data

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

Community Browser