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
Solved! Go to Solution.
@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)]
@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
@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".
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?
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.