Joining Unique Data Tables -Different IDs in Each Table

Hi all,

I have data similar to that attached. I need to join the the two, grouping based off "Group" and "code" fields. However, when one table has a code or group that the other does not it is not joining properly. My current flow uses the summarize tool to group by group and code before joining. and the data is how I need it, however, after joining the data looks like the current tab on the attached instead of one fluent table.

TEST Data.xlsx

Datasets

Join

Accepted answers

atcodedog05

Hi @lomeoari

Hands down @Ar13f 's solution would be best solution for this usecase 🙂.

Here is my understanding of the usecase. If you are getting output as below that means you are using join multiple tool to output all data.

Group	Code	Volume	Q1 Charge	Group	Code	Volume	Q2 Charge
a	1	10	0.16	a	1	10	0.16
a	2	10	0.79	a	2	10	0.79
a	3	10	0.68	a	3	10	0.68
a	4	10	0.26	a	4	10	0.26
a	5	10	0.25	a	5	10	0.25
b	6	10	0.75
b	7	10	0.75
b	8	10	0.48
b	9	10	0.94
				b	15	10	0.32
				b	16	10	0.56
				c	8	10	0.52
				c	9	10	0.50

You can use formula like below to get that data into the required format.

Join tool approach: suggested by @Ar13f is best for 2 data sources.

Join multiple tool approach: is preferable if you have more than 2 data sources. Then you would need to modify your formula with if else statement to get values from other columns.

Hope this helps : )

Join all.yxmd

All comments

Ar13f

Dear @lomeoari

This is what I can give you, please find my workflow.

Maybe there will be other solutions from friends in this community that are even better.

Solution for lomeoari.yxmd

atcodedog05

Hi @lomeoari

Hands down @Ar13f 's solution would be best solution for this usecase 🙂.

Here is my understanding of the usecase. If you are getting output as below that means you are using join multiple tool to output all data.

Group	Code	Volume	Q1 Charge	Group	Code	Volume	Q2 Charge
a	1	10	0.16	a	1	10	0.16
a	2	10	0.79	a	2	10	0.79
a	3	10	0.68	a	3	10	0.68
a	4	10	0.26	a	4	10	0.26
a	5	10	0.25	a	5	10	0.25
b	6	10	0.75
b	7	10	0.75
b	8	10	0.48
b	9	10	0.94
				b	15	10	0.32
				b	16	10	0.56
				c	8	10	0.52
				c	9	10	0.50

You can use formula like below to get that data into the required format.

Join tool approach: suggested by @Ar13f is best for 2 data sources.

Join multiple tool approach: is preferable if you have more than 2 data sources. Then you would need to modify your formula with if else statement to get values from other columns.

Hope this helps : )

Join all.yxmd

lomeoari

I was using join multiple, had three inputs and just made my example two inputs. Great catch, this worked ! Thank you so much!

atcodedog05

Happy to help : ) @lomeoari

Cheers and have a nice day!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335