Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How to copy one column into another sheet?

MandyL
6 - Meteoroid

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!

 

MandyL_0-1584519450938.png         MandyL_1-1584519463804.png

 

Output

MandyL_2-1584519478912.png

 

Best regards,

Mandy

 

4 REPLIES 4
grossal
15 - Aurora
15 - Aurora

Hi @MandyL,

 

you can do this using the Join and Union Tool.

 

grossal_0-1584522543388.png

 

 

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.

VianneyM
Alteryx
Alteryx

Hi @MandyL,

 

You can use the Join Multiple to get both data sources together - configure it as: Join by record position

 

VianneyM_0-1584522755108.png

 

Let me know if you have questions

 

Best,

Vianney 

Best,
Vianney
MandyL
6 - Meteoroid

Thank you @grossal . It works. Thanks!

MandyL
6 - Meteoroid

Thank you @VianneyM. It's works. Thanks!

Labels