I need to rename 2 separate fields to same name

[dmxmikey]

I have 2 separate fields

status and status1 which i want to rename on output to the same name ie livestatus

[sunny_talwar]

Rename them in the script?

[dmxmikey]

thank you, just need script

[petter · Accepted solution]

If both fields are already resident in memory you can't rename either of them to an existing name.

So you have basically two approaches:

1. Make sure that the fields have the common field name in the corresponding LOAD statement.
2. Do a RESIDENT load of the relevant table to rename one of the fields during load.