Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jacek2703
Contributor II
Contributor II

How to load only chosen data?

I have a dataset as below.  How to load only selected "Customer ID"? Eg.  where "Customer ID" = '1213157225' & '1214473707' & '1214986273' & '1214474078'


Przechwytywanie.JPG

 

 

 

 

 

 

LOAD
Source,
"%Partner Store ID",
"%Product ID",
"Product ID",
"%Premium Product ID",
%Date,
"%Customer ID",
"Customer ID",
"%Customer ID Key",
Segment,
"# Sales Out Quantity"
FROM [lib://bms3_emea_root_folder/qvd_facts/f_WESI_SO.qvd]
(qvd);

 

Thank you for any help:

 

 

Labels (1)
1 Solution

Accepted Solutions
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Try this,

where match("Customer ID",'1213157225' ,'1214473707' , '1214986273' , '1214474078');

 

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

2 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Try this,

where match("Customer ID",'1213157225' ,'1214473707' , '1214986273' , '1214474078');

 

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
jacek2703
Contributor II
Contributor II
Author

Thank you so much! And what if I'd like to "add" another filter ie. 

("Customer ID",'1213157225' ,'1214473707' , '1214986273' , '1214474078');

"Product ID" = 57225, 57242, 57422, 57221

?