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

[alec1982]

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. 

[treysmithdev]

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.

[alec1982]

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

[alec1982]

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.

[alec1982 · Accepted solution]

https://community.qlik.com/t5/QlikView-App-Development/Apply-Map-with-wild-Match/m-p/579963