Replace Field with another Field in the same row

[adamgaox]

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

TO

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

[nagaiank]

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;