Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey Guys,
What does the below script does with previous function?
test:
LOAD * Resident test_temp
where Previous(ID)<>(ID)
order by
, Order_date desc
It loads each row where ID is different from the previous row when sorted by code and order_date descending.
Data sorted by Code, Order_Date in descending & Comparing the Previous ID value with the Current ID. If the IDs are different it loads, else skip.