SOLVED
Concatenate data without creating new columns
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ErikaSugi
5 - Atom
2 weeks ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 |
Solved! Go to Solution.
Labels:
- Labels:
- Transforming
3 REPLIES 3
KGT
12 - Quasar
2 weeks ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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...
2 weeks ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you for your help ! It was what I was looking for!
parparab
7 - Meteor
2 weeks ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It is simple use of Union Tool or use union keyward in query