Insert peek values

[Anonymous]

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.

[Anil_Babu_Samineni · Accepted solution]

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;

[Anonymous]

Thanks!)