Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Try this,
where match("Customer ID",'1213157225' ,'1214473707' , '1214986273' , '1214474078');
Try this,
where match("Customer ID",'1213157225' ,'1214473707' , '1214986273' , '1214474078');
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
?