Comparing a Project codes in two Tabels

[rachelmcelhone (Martha McElhone)]

Hi

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?

[SamanGuruge (Palliya Guruge Saman Priyalal)]

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

[rachelmcelhone (Martha McElhone)]

@SamanGuruge

you are going to looking for a string value for don’t use “=” o

Hi @SamanGuruge

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

[rachelmcelhone (Martha McElhone)]

These are the only options in a join activity