Use Case Help! Joining, Union and Sorting

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!

Developer

Join

Preparation

Accepted answers

@ShankerV @Deano478

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

New Workflow2.yxmd

All comments

@cdebacco what are the column headings?

One way of doing this.

Many thanks

Shanker V

Use Case Help Joining, Union and Sorting.yxmd

@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.

@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 @Deano478

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

New Workflow2.yxmd

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703