Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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
Partner Ambassador
Partner Ambassador

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.