Duplicate a single field without RESIDENT LOADing the entire table

[datanibbler]

Hi,

my question is pretty much summed up in the title:

=> I have a table in which there is one field I need to both

     - rename

     - duplicate (with yet another name)

The background is that this field is a keyfield, but I need a duplicate of it that won't be linked so I can properly count it - which doesn't work with keyfields.

Is there any way I can do that without RESIDENT LOADing the entire table?

Thanks a lot!

Best regards,

DataNibbler

[Gysbert_Wassenaar]

Perhaps I don't understand your question, but I'm thinking:

LOAD

     Key,

     autonumber(Key) as CountKey,

     ...other fields...

FROM

Or perhaps even simpler:

LOAD

     Key,

     1 as Counter,

     ...other fields...

FROM

[avinashelite · Accepted solution]

In the same table you can the fields twice rite?

Load

Key,

Key as Count_key,

Key as Test

.....

from

table

[jochem_zw]

‌you can define the field twice and give it a different name.

load

  sample as Key,

  sample as Key2

from ............;