topic Re: Combining Files Into one master file in Alteryx Designer Desktop Discussions

Combining Files Into one master file

rively90 — Wed, 04 May 2022 01:00:56 GMT

Hello!

I'm wondering if there's a way for me to combine these files into two master files (One for sales and one for return)

Also, how do I combine the 3 columns into one? Let's say I want to combine: Mr. + Jon (First name) + Doe (Last name) = Mr. Jon Doe

I hope someone can help with this. Thank you

Qiu — Wed, 04 May 2022 01:14:02 GMT

@rively90
there are a lot of files, can you identify which ones are the master files?

And to join columns we can simply use

'Mr. '+ [Jon (First name)]' ' + [Doe (Last name)]

rively90 — Wed, 04 May 2022 02:17:00 GMT

@Qiu Hello!

I want to combine "Combine Sales and Container 15" Into one

Also

"Combine Return and Container 15" for the other 2.

So, 2 in total

Qiu — Wed, 04 May 2022 06:40:13 GMT

@rively90
These table appear to be normalized tables so we just need find the key column between each other then Join and Join :)

Below is a sample for the "Sales".

rively90 — Wed, 04 May 2022 13:56:19 GMT

thank you so much!

For the return tool container and container 15, do you know what should I do to combine those files?

Also, for the Initial + First and Last name, can we combine those columns in the formula tool? do we need to use CONCAT formula?

rively90 — Fri, 15 Sep 2023 04:59:02 GMT

I know you're expert, thank you.