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 |
Solved! Go to 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
Thank You. It is working