topic How to load only chosen data? in Connectivity & Data Prep

How to load only chosen data?

jacek2703 — Fri, 10 Dec 2021 21:09:00 GMT

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

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:

Re: How to load only chosen data?

kaushiknsolanki — Mon, 05 Jul 2021 17:20:21 GMT

Try this,

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

Re: How to load only chosen data?

jacek2703 — Mon, 05 Jul 2021 19:24:24 GMT

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