How to extract each row of data table into dynamic variable

Akshat_Sharma1 · March 17, 2023, 1:36pm

Hi community,
I have a data table with similar data as shown below:

Now I wish to store each value from column2 into a variable with name as mentioned in column1.
Please help.

Anil_G · March 17, 2023, 1:42pm

Use a dictionary type variable…and then can assign the key as the name and value as the Score

create variable dict of type Dictionary(string,String) and initialize it in a Assign activity using dict = Dictionary(Of String,String)

Then use a for loop on datatable and then use assign inside

dict(currentrow("Name").ToString) = Currentrow("Score").ToString

Hope this helps

cheers

ushu · March 17, 2023, 2:06pm

Welcome to UiPath community!

I agree with @Anil_G approach that suits for your requirement.

Few Point to Add

When you are creating a variable of type dictionary Select System.Collections.Generic.Dictionary(String,String)

Also, at the end if you want to see the Rahul score that was stored in the dictionary then take message box and use below exp

Your Dic var name("Rahul")

Below workflow for your ref