Join one Record with Many

[aysha6029]

Hi Friends,

I have a Scenario below to join one record with multiple record.I will explain the Scenario below. Please help me to solve this issue.

Input

S.No	Name	Address
1	Barabara	Rogers
2	Mike	Frank

S.No	State
1	Texas
2	New Mexico

Required Output

Name	Address	State
Barabara	Rogers	Texas
Mike	Frank	Texas
Barbara	Rogers	New Mexico
Mike	Frank	New Mexico

[MarqueeCrew · Accepted solution]

Try using the APPEND tool (in join category).  It will allow you to do what your trying to accomplish.

https://help.alteryx.com/10.6/index.htm#AppendFields.htm?Highlight=append

Cheers,

Mark

[aysha6029]

Thank You. It is working