Consolidating the unmerged data back for each entry when using Self Join

[Manjunath]

Hey Guys, I have the requirement as shown in the screenshots below 

Input

Input

Expected Output

Expected output

Any Quick help is highly appreciated!

@MarqueeCrew 

[Manjunath]

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.

[JoeS · Accepted solution]

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:

[Manjunath]

Sorry for the delayed response, Thanks a lot @JoeS ! This helped me a lot!

[JoeS]

You're welcome, I am glad I could help!