Table Load Syntax

Mon, 01 Feb 2016 14:51:38 GMT

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,

Re: Table Load Syntax

swuehl — Mon, 01 Feb 2016 15:30:31 GMT

Use a WHERE EXISTS(CustomerID); clause:

Product Table

Load:

ProductID,

CustomerID,

...

FROM PRODUCT;

Customer Table

Loan:

CustomerID,

Name,

...

FROM CUSTOMER

WHERE EXISTS(CustomerID);

topic Re: Table Load Syntax in QlikView

Table Load Syntax

Re: Table Load Syntax