Problem in Dictionary

Help Studio
, ,
1

I have one value in String and another in Number.
I wanto get the DataTable as Dictionary

Help me out.

2

Hi @SP_Bot

Your query is little confusing, can you elaborate.

Regards

3

@Parvathy
I have Datatable with one value in string and another is of Number.
Need Linq Query to convert it into Dictionary

4

Hi @SP_Bot

  1. Use Read Range Activity (Here I’m using Build DataTable) & Store in Variable DT
  2. Use Assign Activity and use below expression
    Note: Dictionary(of String, Object) Type

DT.AsEnumerable.ToDictionary(Function(x) x("Key").ToString, Function(y) y("Value"))

image

image
image1597×542 37.9 KB

Hope it’ll helps you :slight_smile:
Cheers!!

1 Like
Forum Engagement Daily Reports
5

Hi @SP_Bot

Try this query:

dtDictionary.AsEnumerable().ToDictionary(Of String, Integer)(Function(row) row.Field(Of String)("StringColumn"), Function(row) Convert.ToInt32(row.Field(Of Object)("NumberColumn")))

Output DataType is System.Collections.Generic.Dictionary(Of String, Integer)

Hope it helps!!

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.