Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have Year and Month in script and want to add one more column in table which has sequential increment whenever month or year increase . Please suggest the logic to do this.
Thanks Buddy it worked 🙂
Hey Sorry Buddy for incomplete post, next time will keep in mind :-). Thanks for time
Temp:
LOAD Month,
Year,
Sales,
Division
FROM
Data.xlsx
(ooxml, embedded labels, table is Sheet1);
Final:
NoConcatenate
Load *,AutoNumber(Year & Month) Resident Temp Order by Year, Month, Division;
Drop Table Temp;