I wonder if you can advise
I have a DT and variable (I store in variable lets say value TOM JONES)
Im using Lookup Data Table activity and my goal is to find my value in column ‘User’ and have an output from column ‘Role/Responsibility’
I have an issue because in column ‘Users’ I may have several names not only one and my lookup does not work. Once I have only one user name in column ‘User’ then it works fine.
Any suggestion how can I solved it having still several names which are separated by
;Book1.xlsx (9.2 KB)