topic Re: load script in QlikView

load script

Thu, 31 Aug 2017 11:24:54 GMT

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

Re: load script

Anil_Babu_Samineni — Thu, 31 Aug 2017 11:47:26 GMT

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);

Re: load script

Peter_Cammaert — Thu, 31 Aug 2017 11:47:46 GMT

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.

Re: load script

arasaraja_cts — Sat, 02 Sep 2017 07:00:12 GMT

Hi,

PFA, hope it will help.

Thanks

Raja.