How to convert csv file to dictionary in uipath

[Monali_Vekariya]

but where is the output

[ppr (Peter Preuss)]

UiPath Academy

Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

[Dawodm (Mahmoud Dawod)]

Hi @Monali_Vekariya

Please check the following videos:

UiPath | Transpose DataTable using LINQ query | Transpose Collection | Convert Table to Dictionary

UiPath | Convert DataTable To Dictionary | Convert Collection To Dictionary

UiPath | ReFramework Config File | Convert Config File into a Dictionary

[postwick (Paul Ostwick)]

Read CSV into datatable
For Each Row in Datatable

• Assign myDict(CurrentRow(“Name”).ToString) = CurrentRow(“Value”).ToString

[Monali_Vekariya]

could you help me
TASK BY SIR DICTIONARY.zip (6.0 KB)
to do these project please

[ppr (Peter Preuss)]

@postwick

Read CSV into datatable
For Each Row in Datatable

• Assign myDict(CurrentRow(“Name”).ToString) = CurrentRow(“Value”).ToString

As

Assign myDict(CurrentRow(“Name”).ToString) = CurrentRow(“Value”).ToString

is just a shortened repetition of already mentioned

@ppr

For sure you can also create the dictionary by using essential activites

Variable: myDict | DataType: Dictionary(Of String, String) | DefaultValue: new Dictionary(Of String, String)()

• read CSV file into a datatable: Read CSV Activity - output: dtData
• For each row Activity | row in dtData
  • Assign Activity: myDict(row(“Name”).toString.Trim()) =

If(isNothing(row("Value")) OrElse String.IsNullOrEmpty(row("Value").toString.Trim), "", row("Value").toString.Trim)

Also illustrated

@ppr

sometimes copy and paste is failling but when we retype the statements or at least retype every " then it will work

The general modelling should be clear and in your submission you did it also.

@Monali_Vekariya

but where is the output

Here you can do the following within your XAML.

Change variable Scope to higher level:

• Place a comment on the end and set a breakpoint.
• Debug and get paused

Now you can insect the result within the different debug panels (we shared also a helping link for this above)

We do feel as we can see the dictionary that the topic is cleared and can be also closed:
Forum FAQ - How to mark a post as a solution - News / Tutorials - UiPath Community Forum