Looking for Linq Query

[Shriswaroop_Joshi]

Hi , I have an excel sheets having 1 lakhs (attached Input Sheet as an example) + rows and 30 columns. I need to create output sheet based on input sheet as attached. I need to have only one record for every material code as per output sheet. Can some one please help me here? I believe Linq will be better from performance point as I am having huge data

Input Sheet.xlsx (8.2 KB)
Outputsheet.xlsx (8.1 KB)

[Yoichi]

Hi,

Can you try the following sample?

dt.AsEnumerable().GroupBy(Function(r) r("Matrial Code").ToString).Select(Function(g)
    dtResult.Rows.Add({g.Key}.Concat(Enumerable.Range(0,dtResult.Columns.Count-1).Select(Function(i) "0")).ToArray)
    g.ToList.ForEach(Sub(r)
        dtResult.Rows(dtResult.Rows.Count-1)(r("plant").ToString)=r("total").ToString
    End Sub
    )
Return g
End Function).ToList()

Sample20220107-2.zip (14.9 KB)

Regards,

[Shriswaroop_Joshi]

Thanks Yoichi this worked can you please explain me dot net code that will really help me in future. Thanks once again