Incorrect Join and Sort Help!

This is a follow-up to a previous problem I am still having trouble with. This is a simplified version of my actual use case. But below are the data sets, the result I am getting, and the result I want! The workflow is attached too! Do I need a Macro? Should I sort differently? Join them differently? Any help would be greatly appreciated!!

New Workflow2.yxmd

Join

Preparation

Accepted answers

cdebacco

@binu_acs @BS_THE_ANALYST

Figured out a solution this morning! Thanks for your help!!

New Workflow2.yxmd

All comments

binu_acs

@cdebacco

BS_THE_ANALYST

@cdebacco Lol. This was like a puzzle. I tried to organise it according to your sorting? I set it out like a race. Part 1 is furthest to the left. Part 5 is further to the right.

PuzzleLol.yxmd

BS_THE_ANALYST

@cdebacco I struggled to see the logic on why you want it sorted like that? What's the reasoning behind it?

BS_THE_ANALYST

@cdebacco also your text input files didn't match the one's you displayed above. You missed out some records. That was also fun! 😂

binu_acs

@cdebacco not a dynamic solution

New Workflow2 (5).yxmd

cdebacco

@BS_THE_ANALYST Glad you enjoyed it haha

cdebacco

@BS_THE_ANALYST My actual datasets are comparing two excel sheets. An old one and a new one. The new one will have some new rows and some deleted rows of the old one. But, I am trying to automate it so I can see the new additional rows and the old deleted rows in the order they were in the both sheets. The example I gave is a simplified version of this that I am trying to figure out how to do dynamically.

cdebacco

@binu_acs @BS_THE_ANALYST

Figured out a solution this morning! Thanks for your help!!

New Workflow2.yxmd

binu_acs

@cdebacco That is great!!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703