Alternative methods of doing a self-join?

[overhead_press]

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: 

Client	Date	Value 1	Value 2	Value 3
A	2020-01-01	1	2	3
A	2020-01-01	4	5	6
B	2020-02-01	1	2	3
B	2020-02-01	4	5	6

Desired result: 

Client	Date	Value 1	Value 2	Value 3	Value 4	Value 5	value 6
A	2020-01-01	1	2	3	4	5	6
B	2020-02-01	1	2	3	4	5	6

[atcodedog05 · Accepted solution]

Hi @overhead_press 

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

Workflow:

Hope this helps : )

[Qiu]

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

[OllieClarke]

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:

[atcodedog05]

Interesting take @OllieClarke 🙂 guess there is a lot to learn about approaches.

Thank you for the knowledge share 😀

[Qiu]

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

[atcodedog05]

Happy to help : ) @overhead_press 

Cheers and have a nice day!