If a record in one table do not have a record in another table .. add it
Dear Qlikview Community
The hardest part about this question was to find a suiting headline.
The issue at hand is that all suppliers (100.000+) is categorized in one table (SUP_CATEGORY). In a SUPPLIER table all information about our Supplier from Oracle is stored. New suppliers in SUPPLIER will not have a record in SUP_CATEGORY. During the load I want the script to add all new suppliers to SUP_CATEGORY with a default category (MISSING CATEGORY)
EUROPEAN LAB ltd.
88 Lab equipment
After load data in SUP_CATEGORY should be like this: