Hey Guys, I have the requirement as shown in the screenshots below
Input
Expected Output
Expected output
Any Quick help is highly appreciated!
@MarqueeCrew
I feel like I could have done this a little cleaner, but can't think of a way.
Hopefully the annotation explains my thought process:
The requirement is to get values for the close dates from the same dataset.
i.e., For the current Date, item & Dept -> get the matching Close Date, item & Dept values along with the remaining Close Date values.
As of Now I am trying to use Self-Join to pick the Prev Close values for a Date, Item & Dept but I am loosing some amount of information due to Item not present in current date but present in Close date and I am unable to get them back for each date iteratively.
Input
Expected output
