Data table to Dictionary of array conversion

[Aarya_Sajeev]

Can anyone help me to convert datatable to dictionary of array

I’ve list items in datatable format. I need to convert it to dictionary of array variable

[supermanPunch (Arpan)]

Hi @Aarya_Sajeev ,

Could you maybe check with the below post :

How to convert Columns of Datatable to Dictionary?

Hi @Muralikrishna_Surve , Could you Check the below Expression : Assuming you have the Excel data read as a Datatable, say DT. dictVar = DT.AsEnumerable.ToDictionary(Function(x)x("Creation Fields").ToString,Function(y)y("Request Fields").ToString) Here, dictVar is a variable of type Dictionary(Of String,String)

[Anil_G (Anil Gorthi)]

@Aarya_Sajeev

Can you please show your final output needed

What should be the key and what should be the values?

cheers

[Shiva_Nikhil]

@Aarya_Sajeev

dt1.AsEnumerable.ToDictionary(Function(x) x(0).tostring,Function(x) DirectCast(x(1),String()))

[pravallikapaluri]

Hi @Aarya_Sajeev

dataDict(CurrentRow("S.NO").ToString())=CurrentRow.ItemArray

Variables

Hope it helps!!

[sanjay3 (Sanjay)]

Hi @Aarya_Sajeev

Create a dictionary and initialize it
dictionary = New Dictionary(Of String, Object())

Use assign activity
dictionary = dt.AsEnumerable().ToDictionary(
Function(row) row(“YourKeyColumnName”).ToString(),
Function(row) row.ItemArray)

Hope this helps