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
Looks like Im closed to my solution.
So I need one more advise
My User name value (I gave example for TOM JONES) is also stored in variable
I have an excel with list of User names.
I use 1 For Each which give me user name one by one
Then inside 1 For Each I put your For Each
Now I wish to store in variable (I suppose it should be array type) information about all roles that specific User hold because I want to then use them, lets say write in Excel cell
It’s up to you how you then use that. Normally you would want to create a dictionary of key-value pairs which holds all the employee names and their roles. Very easy to work with that then, pasting to excel or using it to access for further analysis in your workflow, whatever you need.