topic Re: Loading data in QlikView

Loading data

riyazasma1009 — Wed, 03 Feb 2016 07:25:36 GMT

Hi All,

I have created a table in the backend as shown below:

ID	@1	@2	@3
1	avsi.txt	abc_def.qvw	v.qvd

I want a table to be created in the backend from the above table. The table should look like as shown below:

Is it possible? If yes, then how can it be achieved?

Thanks,

Asma

sunny_talwar — Wed, 03 Feb 2016 17:17:12 GMT

Use CrossTable() I guess. Is this a Inline Load?

Gysbert_Wassenaar — Wed, 03 Feb 2016 17:23:18 GMT

Perhaps like this:

Result:

CrossTable(ID,Header2)

LOAD 1 as Dummy, @1 as 1,@2 as 2,@3 as 3 INLINE [

ID, @1, @2, @3

1, avsi.txt, abc_def.qvw,v.qvd

];

Drop Field Dummy