topic Re: Load between dates in Connectivity & Data Prep

Load between dates

jacek27031 — Mon, 27 Dec 2021 12:24:19 GMT

Hi, what is wrong with this code?

LOAD
"Buyer ID",
"%Customer ID",
Product,
"%Product ID",
%Date Where [%Date]>Date('10/1/2021') and [%Date]<Date('12/31/2021'),
Quantity,
"Seller Market",
"Type Of Sale"
FROM [lib://bms3_emea_root_folder/qvd_facts/f_channel_stiso_actual.qvd]
(qvd)
Where Match("Seller Market", 'GERMANY');

Re: Load between dates

Or — Mon, 27 Dec 2021 12:59:57 GMT

There's a "Where" in the middle of your Load which shouldn't be there. If this is a condition, it should be at the bottom with the rest of the conditions.

Re: Load between dates

jacek27031 — Mon, 27 Dec 2021 13:13:17 GMT

Thank you @Or , and how to add two conditions?

Re: Load between dates

Or — Mon, 27 Dec 2021 13:25:29 GMT

Where Conditions1

And Condition2

And Condition3

etc.