Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
good morning,
i've got a table like this
LORI | 01/01/2023 | 10 |
LORI | 02/01/2023 | 50 |
i would like to get the number of days between the two days.
Ho can i do it?
thanks
C.
Lets Name these Columns as
Name, Date , Number respectively.
Try this:
A:
Load Name,Date,Number From source.
Noconcatenate
B:
Load *, if(Name=previous(Name),previous(Date)-Date,null()) as Number Of Days
resident A order by Name asc, Date Desc;
Drop Table A;