Use Case Help! Joining, Union and Sorting

[cdebacco]

Hello!

I am looking to join two sources together, and keep all rows, even if they don't match, and keep them in order. 

I have included a simplified example below of what I am hoping to accomplish. 

 I have tried unioning them together but I cannot figure out how to sort them in the right way. 

Thanks in advance for any help!

[Deano478]

@cdebacco what are the column headings? 

[ShankerV]

Hi @cdebacco 

One way of doing this.

Many thanks

Shanker V

[cdebacco]

@Deano478 for the example, it doesn't matter too much. The numbers are the record ID and the other ones can be Field1 and Field2. 

[cdebacco]

@ShankerV Good thinking! Only issue is then they get out of order. Dog and Egg got switched. My real data set has a lot of rows and columns, so it has to be pretty dynamic. 

[ShankerV]

Hi @cdebacco 

Ya I noticed now, then I need to ask a logic here.

Where 2 was given priority in Dataset 1

But when Record ID is given priority in Dataset 2. 

Any logic behind it, so I can implement the same logic too.

[cdebacco]

Thanks the logic want each of the datasets to go in order. Source 1 can go before source 2, but then they match up as the list goes on. I am having trouble implementing it correctly. 

[cdebacco · Accepted solution]

@ShankerV @Deano478 

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