good evening,
I have to extract, from a dictionary, the values in a datatable by correspondence to each column.
My dictionary is as follows: dictionary (of String, dictionary (of String, String)
I can’t loop on the values of my second dictionary in the second loop.
How to also assign its value in the corresponding datatable column?
Thank you for your help
Hi @Julien_Horreau ,
I believe you would not require the inner For Each
activity. We could directly assign Inner Dictionaries values to the Add Data Row
activity.
Give a try by using currentItem.Value.Values
in ArrayRow
property of Add Data Row
activity.
The DataRow
property is not needed.
Let us know if this doesn’t work.
supermanPunch:
I believe you would not require the inner For Each
activity. We could directly assign Inner Dictionaries values to the Add Data Row
activity.
Give a try by using currentItem.Value.Values
in ArrayRow
property of Add Data Row
activity.
The DataRow
property is not needed.
Let us know if this doesn’t work.
no, it doesn’t work, it turns that back to me:
Thanx
@Julien_Horreau ,
It was mentioned to remove the value in DataRow
property and add the suggested Expression to ArrayRow
property.
Hi @Julien_Horreau ,
Slight modification to the Expression :
currentItem.Value.Values.ToArray
system
(system)
Closed
December 5, 2023, 8:15pm
7
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.