load script

[#1]

hi all,

i have table like below

id	Header 2	Header 3	Header 4	Header 5
1	a	b	c	d
2	b	d
3	a	c	b
4	d

and i want data like

id	Header 2
1	a
1	b
1	c
1	d
2	b
2	d
3	a
3	c
3	d
4	d

[Anil_Babu_Samineni]

May be this?

CrossTable(Headers, [Header 2])

LOAD id, [Header 2], [Header 3], [Header 4], [Header 5]

FROM [https://community.qlik.com/message/1335629]

(html, codepage is 1252, embedded labels, table is @1);

[Peter_Cammaert]

Check out the CROSSTABLE Load prefix. It allows you to serialize all data that was originally presented in a matrix layout. It also comes with a greate wizard in the Script Editor, on condition that you load your data from an external source.

See: Crosstable ‒ QlikView

For a more to-the-point exmaple, please post your data in a text/Excel file.

[arasaraja_cts]

Hi,

PFA, hope it will help.

Thanks

Raja.