Alteryx Designer Desktop Discussions

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

Alternative methods of doing a self-join?

overhead_press
8 - Asteroid

I have the following dataset I would like to join onto itself using Client and Date as the connectors, how can i achieve my results without using the join tool to join onto itself because it creates multiple duplicate records for each? Thanks in advance

 

Data: 

ClientDateValue 1Value 2Value 3
A2020-01-01123
A2020-01-01456
B2020-02-01123
B2020-02-01456

 

Desired result: 

ClientDateValue 1Value 2Value 3Value 4Value 5value 6
A2020-01-01123456
B2020-02-01123456
6 REPLIES 6
atcodedog05
22 - Nova
22 - Nova

Hi @overhead_press 

 

Here is how you can do it. This solution is dynamic.

Workflow:

atcodedog05_0-1642403418115.png

 

Hope this helps : )

 

Qiu
21 - Polaris
21 - Polaris

@overhead_press 
I also gave a try.
I think the tricky part is the naming convention for the new header.

0117-coreytan.PNG

OllieClarke
15 - Aurora
15 - Aurora

Hey @overhead_press basically the same approach as @Qiu and @atcodedog05, but you can simplify the naming by using the add prefix option in the dynamic rename tool:

OllieClarke_0-1642418573505.png

 

atcodedog05
22 - Nova
22 - Nova

Interesting take @OllieClarke ðŸ™‚ guess there is a lot to learn about approaches.

 

Thank you for the knowledge share ðŸ˜€

Qiu
21 - Polaris
21 - Polaris

@OllieClarke 
Nice one.
I should keep this in mind.

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @overhead_press 

Cheers and have a nice day!

Labels
Top Solution Authors