Alteryx Designer Cloud Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Cloud.
SOLVED

Concatenate data without creating new columns

ErikaSugi
5 - Atom

 I would like to two files .

Then if two files have the same columns names,I woule like to concatenate below last line in left(or right)data.

Does anybody know function for this? I'm new for Trifacta. I would appreciate your help!

 

Example:

 

1.Right data 

No.FruitQty
1Apple1
2Banana2
3Orange3
4Apple4
5Banana5

2. Left data

No.FruitQty
1Banana5
2Apple2
3Banana6
4Orange5
5Banana4

Combined result

No.FruitQty
1Apple1
2Banana2
3Orange3
4Apple4
5Banana5
1Banana5
2Apple2
3Banana6
4Orange5
5Banana4

 

3 REPLIES 3
KGT
12 - Quasar

I hope I haven't missed something there... it's just stacking the data?

 

Take a look at the Union tool: https://help.alteryx.com/aac/en/designer-experience/designer-cloud-tool-list/cloud-native-mode-tools...

 

ErikaSugi
5 - Atom

Thank you for your help ! It was what I was looking for!

parparab
7 - Meteor

It is simple use of Union Tool or use union keyward in query