Alteryx designer Discussions

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

For each of the row, combine with another column

Highlighted
5 - Atom

Hi,

 

I have two csv files, one has a column:

username
Jessica
Tim
Kevin
David

 

Another csv file has a column

website
google.com
facebook.com
apple.com

 

I'd like to get the following output, how it can be done ?

usernamewebsite
Jessicagoogle.com
Jessicafacebook.com
Jessicaapple.com
Timgoogle.com
Timfacebook.com
Timapple.com
Kevingoogle.com
Kevinfacebook.com
Kevinapple.com
Davidgoogle.com
Davidfacebook.com
Davidapple.com

 

 

 

Highlighted
Alteryx Certified Partner

Hi @xuesmile,

 

The append fields tool would achieve what your looking to try and do:

 

image.png

 

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

 

Regards,

Jonathan

Highlighted
5 - Atom

Cool, It works.Thank you, Jonathan.

 

Labels