Comparing a Project codes in two Tabels


I have two datatables, one with a list of active project codes and the second table contains a list of projects, i want to compare the codes in the first table to the second and remove any codes which dont match in both tables. I tried to join the tables with an inner join but it doesnt seem to be working. Any ideas?

Hi @rachelmcelhone,

In here you are going to looking for a string value for don’t use “=” operation instead of use contain operation the is will work for sure

Happy Automation

Hi @SamanGuruge

I dont have the option to use contain in the join table activity, how would i go about it?

These are the only options in a join activity