Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

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