Concatenate data without creating new columns

[ErikaSugi]

 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.	Fruit	Qty
1	Apple	1
2	Banana	2
3	Orange	3
4	Apple	4
5	Banana	5

2. Left data

No.	Fruit	Qty
1	Banana	5
2	Apple	2
3	Banana	6
4	Orange	5
5	Banana	4

Combined result

No.	Fruit	Qty
1	Apple	1
2	Banana	2
3	Orange	3
4	Apple	4
5	Banana	5
1	Banana	5
2	Apple	2
3	Banana	6
4	Orange	5
5	Banana	4

[KGT · Accepted solution]

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]

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

[parparab]

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