Specific data (few item numbers) in Load

[#1]

Very simple question: in a QVD I have over 20.000 item numbers. However in my report I just need four of those. How do I just load those 4 item numbers in my script?

Thanks in advance.

[Anonymous · Accepted solution]

Load *

From ...

where match(ItemNo,'1','2','3','4');

=> Replace with your itemNo's - the specified text must be an exact match.

[stabben23]

Hi,

Items is often a part of the fact table and also a part of its own dimensiontable.

So if you filter the items you want in Your dimensiontable With something like: where match(item,1,2,3,4)

then in facttable use: where exists(item,item).

this will reduce Your Whole datamodel to contain only Your 4 items.

[#4]

Thanks, this is what I needed.