Hi Mattia,
As long as we need to simplify - such operators would be different JOINs (Left Join/Right Join/Inner Join/Outer Join)
Mapping field may be another method to achieve this.
Basically, you need to know what you want to do with the data.
Here is an example of how you can use Left Join:
T1:
LOAD * INLINE [
Amount, Country, Year
100, Italy, 2019
150, UK, 2019
140, Australia, 2019
];
LEFT JOIN (T1)
LOAD * INLINE [
Country, Region
Italy, EU
Australia, AUS
];
Here are results:
| Amount | Country | Year | Region |
| 100 | Italy | 2019 | EU |
| 150 | UK | 2019 | - |
| 140 | Australia | 2019 | AUS |
