One way is to read in the product table as a mapping table, then map the ProductCode to the Product with applymap(). Something like this:
[Products]: MAPPING LOAD CFTCode, Product FROM wherever ; [Sales]: LOAD DepotCode ,applymap('Products',ProductCode) as Product ,Quantity ,SalesDate FROM wherever ;
Another way is a left join:
[Sales]: LOAD DepotCode ,ProductCode ,Quantity ,SalesDate FROM wherever ; LEFT JOIN (Sales) LOAD CFTCode as ProductCode ,Product FROM wherever ; DROP FIELD ProductCode ;
Another way is to just leave the tables separate, and let QlikView handle them via association:
[Sales]: LOAD DepotCode ,ProductCode ,Quantity ,SalesDate FROM wherever ; [Products]: LOAD CFTCode as ProductCode ,Product FROM wherever WHERE exists(ProductCode,CFTCode) ;
