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 xx@xx.com only with the associated data. Then the gg@gg.com and its data and the PP@PP.com.

Thanking you

Hey,

You can use the Lookup DataTable Activity

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

Thanks

1 Like

Hi,

How about the following?

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

Sample20220725-7.zip (3.0 KB)

Regards,

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.