Can i reference a single column in mapping load with itself

siddharthsoam — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Can i reference a single column in mapping load with itself

Anil_Babu_Samineni — Wed, 13 Dec 2017 05:35:45 GMT

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;