Change one field name into another field value.

[Architect]

Hi, Below you can see there is one table, having 5 columns.

START	END	SUBDIVISION	DAYS	DELAY
1234	567	REGULAR	100	10

here 5th column is 'DELAY' and the value is '10'.

what we have to do is make 'DELAY' a field value under 'SUBDIVISION', and '10' will become its corresponding

value under column 'DAYS'. the new table is like below--

START	END	SUBDIVISION	DAYS
1234	567	REGULAR	100
1234	567	DELAY	10

can you help with the solution, how to achieve this?

[edwin · Accepted solution]

if there are no complications, this should do:

concatenate (table)
load START, END, 'DELAY' as SUBDIVISION, DELAY as DAYS
resident table;

drop field DELAY from table;

[Architect · Accepted solution]

Thanks @edwin .

logic is working perfectly.

[edwin]

yw