Compare dictionary with data table

[Datta_Annaram]

HI ,
Can anyone help me with below query:
I have dictionary contains data and i have data table , so i need to compare the key value of dictionary with data row of data table when both are matched i need to add the value of dictionary from the another of data table

[Datta_Annaram]

from the Above two pics i need to add the values of datable Sum(Number of hours) into the dictionary of value

[Dave (David Wiebelhaus)]

I would suggest using a LINQ statement with a GROUP BY function on the datatable to sum up the [Number Of Hours] column by [WBS_Level 6_Task Name]

Then you can use a for each statement to loop over the dictionary.keys and check if the key.tostring is found in the [WBS_Level 6_Task Name] column. If it is, then use an assign activity to change the key’s value in the dictionary. You can do this comparison by iterating through each row in the datatable, or by using another LINQ query

[ppr (Peter Preuss)]

Discussion was forked by author and continues here:

For Each: Collection was modified; enumeration operation may not execute in dictionary

HI, Can anyone help me to overcome above error "For Each: Collection was modified; enumeration operation may not execute in dictionary " When I am trying to add value to the dictionary inside the loop, it’s throwing above error , when condition is met it is adding values to dictionary when the condition failed then it is looping 3 to 4 rows then it is throwing the error of above mentioned, please help me [For each] [for each 2] [Error]

[Cristian_Negulescu]

Hello Datta,
In this video I have multiple examples with Dictionary:

Multiple use-cases for List(Collection) and Dictionary in UiPath | UiPath Collection

Thanks,
Cristian Negulescu

[vishakhakolhe.kolhe (Vishakha Kolhe)]

If we can use the data from data table, then why to use dictionary. why we convert data table into dictionary and then use it.