I don't understand how you did it.
Normally, where exists and applymap are used in different scenarios.
Where exists is used to filter data, applymap is "normally" used to substitute data instead of joining it.
,applymap('MyMap', field2, field2) as field2_description
Hi Magnus Åvitsland,
first of all thank you for your reply.
let me to explain how i applied those scenarios.
in "where exists" i firstly loaded the table that contains the field i want to use for filter. then i pulled the data from my main qvd filtering with "where exists(field1)"
from x.qvd where fieldX <> 'A';
from main.qvd where exists(field1);
in the second scenario, "applymap", i created a mapping_load table than executed the main load filtered by applymap.
from main.qvd where applymap('table1',field1) <> 'A';
the scripts are just as like above. did i do something wrong ?