Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi i have imported various qvds into my qlikview document. One of them being a product qvd that contains thousands of product numbers. I would like to ask how i would specify in the script to only load a certain view of these products
for example
501,502,503,504
These are all product numbers
Hi Aaron,
Load *
From
Product.qvd (qvd)
Where Match(Product_Field, '501','502','503','504')
You can also try like below
Product:
LOAD * INLINE [
Products_To_Load
501
502
503
504
];
Data:
Load *
From
Product.qvd (qvd)
Where Exists(Products_To_Load, Product_Field);
DROP Table Product;
Hi Aaron,
Load *
From
Product.qvd (qvd)
Where Match(Product_Field, '501','502','503','504')
You can also try like below
Product:
LOAD * INLINE [
Products_To_Load
501
502
503
504
];
Data:
Load *
From
Product.qvd (qvd)
Where Exists(Products_To_Load, Product_Field);
DROP Table Product;