Dear Team,
I am new to Alteryx and would like to do a lookup of ID column and if it matches, then copy the value of Region into another column.
Could you please suggest or any help is highly appreciated here.
| ID | Region |
| 2 | India |
| 4 | Germany |
| 5 | France |
| 6 | US |
| 7 | UK |
| ID | PinCode | Region |
| 5 | 2345 | |
| 3 | 52312 | |
| 6 | 34634 | |
| 2 | 26234 | |
| 3 | 236234 | |
| 4 | 26243 | |
| 5 | 36234 | |
Output:
| ID | PinCode | Region |
| 5 | 2345 | France |
| 3 | 52312 | |
| 6 | 34634 | US |
| 2 | 26234 | India |
| 3 | 236234 | |
| 4 | 26243 | Germany |
| 5 | 36234 | France |
