Group excel records

Help Activities
, ,
1

Sample.xlsx (8.2 KB)
i wants to process the records with same name & date, so how can i achive this?

2

Hi,

How about the following using LINQ GroupBy and Dictionary.

dict  = dt.AsEnumerable.GroupBy(Function(r) Tuple.Create(r("Fund Name").ToString,r("Date").ToString)).ToDictionary(Function(g) g.Key,Function(g) g.CopyToDataTable)

dict is Dictionary<Tuple<T1,T2>,DataTable> type.

Then iterate it using ForEach

Sample
Sample20230206-1aL.zip (8.8 KB)

Regards,

1 Like
3

Thanks @Yoichi its working

4

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