Load From QVD Where MATCH from Previous Qlikview Table
I am trying to create a load for Customer Orders where the field Order Code is in the list of Codes brought back from the previous tab, which is the load for the order codes needed for this area of the business.
I know that I can use the MATCH keyword but not sure how I can link the field from the Customer Order load to the appropriate field in Order Code.
I need something along the lines of;
where match(c_order_code,(load order_code from order_codes));
Yes, that is right. order_codes need to be in a table which has already been loaded. Also need to make sure that there are no other instances of order_codes available in other tables because Exists check against field value and not against field value from a certain table. So make sure to give this field a uniquename for comparison, may be something like this: