Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Load *
From ...
where match(ItemNo,'1','2','3','4');
=> Replace with your itemNo's - the specified text must be an exact match.
Load *
From ...
where match(ItemNo,'1','2','3','4');
=> Replace with your itemNo's - the specified text must be an exact match.
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.
Thanks, this is what I needed.