For each of the row, combine with another column

[xuesmile]

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 ?

username	website
Jessica	google.com
Jessica	facebook.com
Jessica	apple.com
Tim	google.com
Tim	facebook.com
Tim	apple.com
Kevin	google.com
Kevin	facebook.com
Kevin	apple.com
David	google.com
David	facebook.com
David	apple.com

[Jonathan-Sherman · Accepted solution]

Hi @xuesmile,

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

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

[xuesmile]

Cool, It works.Thank you, Jonathan.