Good afternoon i'm new using alteryx, and i'm trying to work with two different files from excel,
The file No.1 contain this information
| Codice | Denomination | No. Invoice from other countries |
| 5 | Company X | 25.000 |
| 4 | Complany Z | 85.000 |
| 9 | Company Y | 15.000 |
The file No.2 contain this information
| Society | Ord num | Code | Denomination | Responsible |
| SErvices | 60026926 | 60-2458-353 | Company G | Lucas |
| SErvices | 60026945 | 60-2458-224 | Company X | Matteo |
| SErvices | 60025685 | 60-2458-169 | Company Y | Peter |
| SErvices | 600264546 | 60-2458-698 | Company L | Fernando |
And i'm trying to obtain an unique file like this
| Codice | Denomination | No, Invioce from other countries | Society | Ord Number | Code | Responsible | Cluster |
| 5 | Company X | 25.000 | SErvices | 60026945 | 60-2458-224 | Matteo | |
| 4 | Company Z | 85.000 | SErvices | | | | |
| 9 | Company Y | 15.000 | SErvices | 60-2458-169 | 60-2458-169 | Peter | |
The unique file (file No1) has to get the information from file No.2 according the Denomination (company), with a new blanck column called Cluster
How can i get the right information from file no 2 and put it into the right company
I'll appreciate if anyone could help me
