Hi,
There are two different columns, one is on the sheet1 called "Product Line", and the other is on the sheet2 called "User". May I know to output these two columns in one sheet? like excel copy and paste function, just copy one column to another sheet. Thanks!
Output
Best regards,
Mandy
Solved! Go to Solution.
Hi @MandyL,
you can do this using the Join and Union Tool.
You join the records by position resulting in a dataset with the first 3 rows and than union all "not matched" columns from the R Anker.
Sample workflow attached. Let me know if this helps.
Regards
Alex
PS: If sheet 1 has more records than sheet 2 or you don't know which one will have more records, you should also connect the L anker to the Union Tool, but be careful, always connect the J Anker first to the Union tool.
Hi @MandyL,
You can use the Join Multiple to get both data sources together - configure it as: Join by record position
Let me know if you have questions
Best,
Vianney
Thank you @grossal . It works. Thanks!
Thank you @VianneyM. It's works. Thanks!