topic SV:Re: SV:Re: SV:Load syntax in QlikView

Load syntax

Wed, 17 Nov 2010 09:25:41 GMT

Hi,

I am loading one table: productsA and want to load the other tables only when the Product_ID exists in the first table because the other tables have many posts that has nothing to do with productsA. How is the load syntax for that?

//Liivi

SV:Load syntax

Wed, 17 Nov 2010 09:44:07 GMT

Writing syntax from memory but something like this should work.

Products:
Load
ProductID,
ProductNM;
SQL SELECT ProductID, ProductNM
FROM MyTable;

ProductSpecification:
Load
ProductID,
ProductWeight
WHERE EXISTS(ProductID);
SQL SELECT ProductID, ProductWeight
FROM MyOtherTable;

/Michael

SV:Load syntax

Wed, 17 Nov 2010 10:53:17 GMT

But in this syntax you don't specify that the product_ID that I load from other table must exixt in the first table

SV:Re: SV:Load syntax

Wed, 17 Nov 2010 11:18:26 GMT

Yes I do. I explicitly state that ProductId must exist in the already loaded data. Hence the bold part.

SV:Re: SV:Load syntax

Wed, 17 Nov 2010 11:38:59 GMT

As it seems it worked,

but what happens if I want to load more tables with this sytnax, does it always look on the product_ID in the first table?

SV:Re: SV:Re: SV:Load syntax

Wed, 17 Nov 2010 14:17:56 GMT

No it looks at all the already loaded ProductID's. If you only want to check against the ProductID's from the firstly loaded table but not other loaded ProductID's (if you load data between the two) you can load it with an alias, I.e:

Products:
Load
ProductID
ProductID as MyProductID,
ProductNM;
SQL SELECT ProductID, ProductNM
FROM MyTable;

ProductSpecification:
Load
ProductID,
ProductWeight
WHERE EXISTS(ProductID, MyProductID);
SQL SELECT ProductID, ProductWeight
FROM MyOtherTable;

SV:Re: SV:Re: SV:Load syntax

Fri, 26 Nov 2010 08:40:21 GMT

Thanx a lot!!!