Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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');
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.
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.
Thank you @Or , and how to add two conditions?
Where Conditions1
And Condition2
And Condition3
etc.