Hello, I have a tricky situation where I need to look up for ID and Name column in one data table and check if is on another table
How could this work?
ex. Table 1
The thing is that this ID repeats for other names that is why I need to make this ‘double’ lookup
Join Data Table should help in this case.
Sorry unable to get this point.
Means that by my example the ID can be the same for more than one name and that is the reason I need to look up for 2 values at same time
How would Join data table work?
When it’s there for 2 names still you want make it consider as match right ?
It gonna join the tables based on a column match which you choose between tables ( you can also customize join and choose multiple columns also )
Have you check the lookup datatable activity?