Previous function

[krishna20]

Hi Folks,

I am having date and I need New date fields's data should be like below. How can I achieve this at script level as a new field using peek or previous functions.

Date	New Date
01-09-2018	02-09-2018
02-09-2018	03-09-2018
03-09-2018	04-09-2018
04-09-2019	05-09-2018
05-09-2018	06-09-2018
06-09-2018	07-09-2018
07-09-2018	-

Regards

krishna

[shiveshsingh]

Hi

Try this

T:

load Date#(Date,'DD-MM-YYYY') as Date;

load * inline

[Date

01-09-2018,

02-09-2018,

03-09-2018,

04-09-2018,

05-09-2018,

06-09-2018,

07-09-2018];

F:

load Date, Previous(Date) as New_Date

Resident T

order by Date desc;

[krishna20]

Hi Shivesh,

Thanks for your inputs, but not getting exact result.

[jyothish8807]

Hi Kalyan,

Try this:

A:

load Date#(Date,'DD-MM-YYYY') as Date ;

load * inline

[Date

01-09-2018,

02-09-2018,

03-09-2018,

04-09-2018,

05-09-2018,

06-09-2018,

07-09-2018];

NoConcatenate

b:

Load

Date,

previous(Date) as NewDate

resident A

order by Date desc;

drop table A;

Br,

KC

[shiveshsingh]

Sorry, i missed drop table part.

Please refer below code.

T:

load Date#(Date,'DD-MM-YYYY') as Date;

load * inline

[Date

01-09-2018,

02-09-2018,

03-09-2018,

04-09-2018,

05-09-2018,

06-09-2018,

07-09-2018];

F:

load Date, Previous(Date) as New_Date

Resident T

order by Date desc;