Combining Files Into one master file

[rively90]

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]

@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]

@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 · Accepted solution]

@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]

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]

Hi @Qiu  could you please help on https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-do-you-handle-the-nulls-An... 

I know you're expert, thank you.