Hello,
My first question after weeks of reading everyone's great answers!
I am loading a table with an OBDE connection and I wish to filter what to load or realize a JOIN, CONCATENATE, ETC based on a table loaded previously in the script. AS IN
Product Table
Load:
ProductID,
CustomerID, etc
Customer Table
Loan:
CustomerID,
Name, etc
But I only wish to have the data loaded into the Customer table for those customer that exist in the Product table. I'm not sure about JOINS, CONCATENATE, etc in qlikview yet, perhaps these are an easy solution?
If I were to join on the product table would I not have the customer table fields repeated each time I have a particular customerID in the product table?
Could I create a variable in the Customer Table load?
Many thanks for your help,
