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

Hi @overhead_press 

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

Workflow:

Hope this helps : )

Client.yxmd