topic Scripting problem- extracting certain data from a qvd in QlikView

Scripting problem- extracting certain data from a qvd

aaronnayan — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Scripting problem- extracting certain data from a qvd

tamilarasu — Mon, 06 Feb 2017 10:05:33 GMT

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;