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

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