Group by data in DataTable

Hi there.

I have a Data Table with data that I imported via an Excel file that looks like this:

I would like to know how to obtain the addresses only with the associated data. Then the and its data and the

Thanking you


You can use the Lookup DataTable Activity

so it will give the value on the basis of Contact Column


1 Like


How about the following?

dict = dt.AsEnumerable().GroupBy(Function(r) r("Contact").ToString()).ToDictionary(Function(g) g.Key,Function(g) g.CopyToDataTable) (3.0 KB)


1 Like

Perfect ! Thank you so much :slight_smile:

1 Like

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