Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can some one help me to write For Each loop for the below script, as we have to run data Jan 2018, Feb 2018, Mar 2018.......
Table1:
LOAD CustID,
Sales_Date
FROM
Inventry.xlsx
(ooxml, embedded labels, table is Sheet2)
Where Sales_Date>=MonthStart(Today()) and Sales_Date<=MonthEnd(Today());
What's your expected result here? You might be able to achieve your reuirements without loops.