Scripting problem- extracting certain data from a qvd

[aaronnayan]

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

[tamilarasu · Accepted solution]

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;