Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please help me to dynamic change of where clause Sales Date
//Script
T1:
LOAD OrgID,
Sales_Date
FROM
Inventry.xlsx
(ooxml, embedded labels, table is Sheet2)
Where Sales_Date>='11/01/2017' and Sales_Date<='11/30/2017';
NoConcatenate
T2:
Where Sales_Date>='11/01/2012' and Sales_Date<='10/31/2017';
//Script end
Create variable for Sales Date to change based on selected 'monthname' Filed
T1 - selected month
(Ex: select Dec 2017 = Sales_Date>='12/01/2017' and Sales_Date<='12/31/2017'
select Nov 2017 = Sales_Date>='11/01/2017' and Sales_Date<='11/30/2017')
T2 - Last Five years
(Ex: select Dec 2017 = Sales_Date>='12/01/2012' and Sales_Date<='11/30/2017'
select Nov 2017 = Sales_Date>='11/01/2012' and Sales_Date<='10/31/2017')