@rohit782192
you can look into the attached example for better understanding.
also to expain
In the Join Tool in Alteryx, the "Join by Record Position" option allows you to combine two tables based on the position of the rows rather than matching specific column values.
This means the Join Tool will pair the first row of Table A with the first row of Table B, the second row of Table A with the second row of Table B, and so on. It doesn't compare the contents of the cells in the rows; it just matches rows based on their order.
For example, if you have two tables:
Table A:
Name Age
John 25
Jane 30
Table B:
City Country
New York USA
London UK
Using "Join by Record Position," the Join Tool will pair the rows like this:
Joined Table:
Name Age City Country
John 25 New York USA
Jane 30 London UK
In this way, it outputs the rows based on their positions, not by matching the values within the cells.
hope this helps
mark done if solved.
