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 |
