Data Group and Filter Problem

[170290064 (Eyüp Hasan Akbaba)]

Here is my excel file.

sample.xlsx (21.4 KB)

Here are the colors of automobiles

How to grouping the cars on the “Otomobil” page according to their Color values and drawing the value of how many they are in a “Color Quantity Page” ???

Note : Needs to do it with linq methods

[Yoichi]

Hi,

Can you also share expected output?

Regards,

[170290064 (Eyüp Hasan Akbaba)]

Same colors will be following each other.

[Yoichi]

Hi,

How about the following sample?

Sample20230718-1aL.zip (21.0 KB)

Regards,

[170290064 (Eyüp Hasan Akbaba)]

It seems fine but mentor wants me to do it with linq methods

[Yoichi]

@170290064

linq methods

Can you try the following expression?

dt = dt.AsEnumerable.OrderBy(Function(r) r("Renk").ToString).CopyToDataTable

Regards,

[170290064 (Eyüp Hasan Akbaba)]

I ll let you know when i am able to try it

[rushikeshlanke2]

@170290064

How to grouping the cars on the “Otomobil” page according to their Color values and drawing the value of how many they are in a “Color Quantity Page” ???

please find the attched result file.
sample.xlsx (20.9 KB)

for linq you can use following query,

Dt2=Dt.AsEnumerable().OrderBy(Function (row) row(“Renk”).ToString).Select(Function (row) row).ToArray.CopyToDatatable()

[170290064 (Eyüp Hasan Akbaba)]

Yes it works but i also want to count how many different colours and total numbers of colours like in the following.

[Yoichi]

Hi,

How about the following sample? This outputs count sheet in Sheet2.

dtCount =dt.AsEnumerable.GroupBy(Function(r) r("Renk").ToString).Select(Function(g) dtCount.LoadDataRow({g.Key,g.Count},False)).CopyToDataTable()

Sample20230718-1aLv2.zip (22.5 KB)

Regards,

[170290064 (Eyüp Hasan Akbaba)]

Also it has to be string, right ?

[Yoichi]

Hi,

Does the above sample work? Did you modify the workflow?
For now, can you check dtResultsPage and/or dtRenkAdet is null or not at Locals panel when error occurs?

Regards,

[170290064 (Eyüp Hasan Akbaba)]

My bad!

Output of Build Data Table was empty

Thanks for the solution