Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Colleagues, good day!
Would be glad to get some advise to solve this task:
I have simple table with following structure:
i need to insert to this table several records (per each month) with this condition:
id - get previous id value
date - get monthend value
sales1 - get previous value
Sales2 - get previous value
so the result should be the following:
There's sample in the attachment.
Thanks.
Does this make sense?
//Script:
Main:
LOAD id,
Date,
Sales1,
Sales2
FROM
Test1.xlsx
(ooxml, embedded labels, table is Sheet1);
Join
LOAD id, Sales1, Sales2,MonthEnd(Date) as Date Resident Main;
Does this make sense?
//Script:
Main:
LOAD id,
Date,
Sales1,
Sales2
FROM
Test1.xlsx
(ooxml, embedded labels, table is Sheet1);
Join
LOAD id, Sales1, Sales2,MonthEnd(Date) as Date Resident Main;
Thanks!)