Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
alec1982
Specialist II
Specialist II

change value in column based on values from external table. apply map is not the solution

hi all,

anyone has a quick logic where i can change values in a field based on external table. 

I have the external table with two columns A, B

then I have a table that contain C,D and F columns.

I want to create a column L with the following logic.

If Column C contain a value from column A then use B and name the column L. 

1 Solution
4 Replies
treysmithdev
Luminary Alumni
Luminary Alumni

How big is your dataset? Depending on your data volume you could use a loop. However, if it is quite large then you will need to tackle it a different way. I would suggest using a Generic Load after mapping in the values and field name using ApplyMap. Here is a great blog post on how to use Generic Load by HIC: The Generic Load.

Blog: WhereClause   Twitter: @treysmithdev
alec1982
Specialist II
Specialist II
Author

thxs for your help. as stated on the subject. apply map is not the case. need different logic as data set is big.

alec1982
Specialist II
Specialist II
Author

also, I am not sure about the generic load. I dont think it is relevant to the question as I dont need to create columns for each value.