Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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;