Loading data

[riyazasma1009]

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:

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

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

Thanks,

Asma

[sunny_talwar]

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

[Gysbert_Wassenaar]

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