Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
datanibbler
Champion
Champion

Duplicate a single field without RESIDENT LOADing the entire table


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

1 Solution

Accepted Solutions
avinashelite

In the same table you can the fields twice rite?

Load

Key,

Key as Count_key,

Key as Test

.....

from

table

View solution in original post

3 Replies
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


talk is cheap, supply exceeds demand
avinashelite

In the same table you can the fields twice rite?

Load

Key,

Key as Count_key,

Key as Test

.....

from

table

jochem_zw
Partner Ambassador
Partner Ambassador

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

load

  sample as Key,

  sample as Key2

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