Can i reference a single column in mapping load with itself

[siddharthsoam]

Hi

I want to create a mapping load with reference as the same column. For example,

mapping load

customer as customer1,

customer

resident resource

I want to use this new customer1 column in some other table. Is it

[Anil_Babu_Samineni]

First of all, Qlik Doesn't allow unique fields. To understand better we can achieve like below?

Table:

Load customer From Table;

Join

Load customer as customer1 Resident Table;

Final:

NoConcatenate

Mapping Load * Resident Table;

Drop Table Table;

Sales:

Load Field, ApplyMap('Final', customer1, 'NA') as customer1 From Sales;