Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Joining Unique Data Tables -Different IDs in Each Table

lomeoari
7 - Meteor

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. 

5 REPLIES 5
Ar13f
10 - Fireball

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.

atcodedog05
22 - Nova
22 - Nova

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.

atcodedog05_0-1634710128584.png

 

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 : )

 

Ar13f
10 - Fireball

Dear @atcodedog05 

 

Thanks for the advice and sharing the knowledge ..

lomeoari
7 - Meteor

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

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @lomeoari 

Cheers and have a nice day!

Labels