DT row to dictionary, one key n-values

Help Studio
1

Hey,
I am trying to add data row from data-table with n-columns to data dictionary. This will be one key with many values, depending on the column you call from your dictionary.
for ex., in pseudo
|Testcase |TravelCntry|TravelDestination_1|TravelDestination_2|Adult1Age|Adult2Age|FName|LName|
TripCanada | Canada | Ontario | Quebec | 38 | 28 | John |Doe|

and many more columns for the testcase, so I have selected that row, I should be able to recall
row(“TripCanada”).Value(TravelDestination_1), this should give me Ontario
I tried using tuples, but tuples doesn’t count for unknown number of columns.

2

Loop on column names from datatable and add values from the current row to the dictionary.
Dictionary (ColumnName)= Your value

3

I already have values in dt, I want to be able to read the values by name from dictionary. Also, the columns length is unknown, it is on the fly suck the data in the data dictionary and then recall in application particular data wherever it is needed

4

Hi @Nick101 ,

Maybe you can use the datatable itself in the below way :

DT.AsEnumerable.Where(Function(x)x("Testcase").ToString.Trim.Equals("TripCanada")).First.Item("TravelDestination_2").ToString

image

You can use a variable in place of TripCanada value. So that dynamically you can pass the values and get the data.

5

Will it account for unknown number of columns? I want to create this as generic, so some dt may have 10 columns and other may have 20

6

Also, I may not be in the same sequence, so little more explanation:
I loop through the dt until I find the testcase.
Once I find the testcase, I want to capture that in dictionary.
Then I leave the dt loop and continue to my application

7

Hi,

If my understanding is right, perhaps you should use Dictionary<string, Dictionary<string,string>> as the following sample.

image
image880Ă—608 44.2 KB 

dict = dt.AsEnumerable.ToDictionary(Function(r) r(0).ToString,Function(r) Enumerable.Range(0,dt.Columns.Count).ToDictionary(Function(i) dt.Columns(i).ColumnName,Function(i) r(i).ToString))

Sample20230602-2aL.zip (2.7 KB)

Regards,

8

I’m curious why you need to put the row into a dictionary when you can just reference the row values when you need them as you loop through the datatable.

9

This will go in the library. There will be many testcases/rows, I need to find the one I am looking for and exit the dt. Then I should be able to use the dict values outside of the loop.

10

Thanks you! Works like a charm.

1 Like
12

Ok then it’s a reasonable process to put it into a dictionary. Another option would be just capture the row index - then you can directly reference the row outside the loop.

13

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