Can you please guide me on achieving this task?
I’m using an excel read range to get data from two columns (Ex: Col 0, Col 1) and storing in Data Table.
Now I want to assign each value of col 1 to a new variable by checking the values of col 0. Please see the below screenshot.
Variable 1= john (before assigning this I want to check whether col 0 value is “Name”)
Variable 2= US(before assigning this I want to check whether col 0 value is “Country”)
I tried for each row with assign activity but it’s assigning same row value to all the variables.
Please advice. Thanking you in advance!