Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
siddharthsoam
Partner - Creator II
Partner - Creator II

Can i reference a single column in mapping load with itself

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

1 Reply
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;

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful