topic Replace Field with another Field in the same row in QlikView

Replace Field with another Field in the same row

adamgaox — Tue, 18 Nov 2014 03:31:12 GMT

Hi All,

I'm finding a way to replace Field with another field in the same row.

Chaning Table

A 1	A 2	A 3	A 4	A 5	A 6
X1					X1-1111

A 1	A 2	A 3	A 4	A 5	A 6
X1	X1	X1	X1	X1	X1-1111

nagaiank — Tue, 18 Nov 2014 03:41:15 GMT

If Table1 has fields A1 and A6, you may the following script to get the Table2 with fields A1, A2, A3, A4, A5 and A6:

Table2:

Noconcatenate

load A1, A1 as A2, A1 as A3, A1 as A4. A1 as A5, A6 resident Table1;