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?
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
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