For each of the row, combine with another column

Question

Hi,

I have two csv files, one has a column:

usernameJessicaTimKevinDavid

Another csv file has a column

websitegoogle.comfacebook.comapple.com

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

usernamewebsiteJessicagoogle.comJessicafacebook.comJessicaapple.comTimgoogle.comTimfacebook.comTimapple.comKevingoogle.comKevinfacebook.comKevinapple.comDavidgoogle.comDavidfacebook.comDavidapple.com

Jonathan-Sherman · Accepted Answer

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