Group by data in DataTable

[DimitriLYR]

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

[Rounak_Kumar1 (Rounak Kumar)]

Hey,

You can use the Lookup DataTable Activity

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

Thanks

[Yoichi]

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,

[DimitriLYR]

Perfect ! Thank you so much