Hi,
I need to compare data from 2 tables ie, First table i have some data and the second table is a lookup table. Based on the comparison, i have to take the data from the lookup table and update in the third table. Please find my scenario below. Kindly help me to solve this issue. Please help me to design workflow in alteryx
Table 1
| S.No | Name | Address | Jurisdiction |
| 1 | Hannah | Alabama | America |
| 2 | Pete | Leeds | United Kingdom |
| 3 | Sager | California | America |
Table 2(Lookup Table)
| Jurisdiction | Country |
| America | USA |
| United Kingdom | UK |
Required Table After comparison
| S.No | Name | Address | Jurisdiction |
| 1 | Hannah | Alabama | USA |
| 2 | Pete | Leeds | UK |
| 3 | Sager | California | USA |
