Filter the Column Values and get it Count in linq

[Shyam_Pragash]

Hi Team,

I have a datable table in that table get specific columns to filter values based on the condition and get it count using linq.

Thanks
Shyam

[prateek.mehandiratta9 (Prateek Mehandiratta)]

Here is a sample

d1.asEnumerable.where(Function(x1) CInt(x1(“Sal”))>500).copyToDatatable

D1.Rows.Count or you can use Count function on the Linq itself

Here exactly:

dt.AsEnumerable.Where(Function(x) x(“Column2”).ToString<>Nothing).Copytodatatable.RowCount>0

[Shyam_Pragash]

Hi @prateek.mehandiratta9

Sample data table

show in the columns i have get the count from Rep and Item columns

Thanks
Shyam

[prateek.mehandiratta9 (Prateek Mehandiratta)]

You have to get row count from Rep item column and also from item column? You want each column count separately.

What filter you want to use?

[Shyam_Pragash]

Hi @prateek.mehandiratta9

i want each column items count separately

Thanks
Shyam

[prateek.mehandiratta9 (Prateek Mehandiratta)]

Hi,

Try here:

Linq Query to get the count of a value in particular column of datatable - Help / Activities - UiPath Community Forum

dt.AsEnumerable.Count(Function(r) r(“Rep”))

[ppr (Peter Preuss)]

Give a try at

dictGroupCount | Dictionary(Of String, Int32) =

YourDataTableVar.asEnumerable.GroupBy(Function (x) x("Item").toString.Trim).ToDictionary(Function (x) x.Key, Function (x) x.Count)

[Shyam_Pragash]

Hi,

getting on error

refer screen shot

Thanks
Shyam

[Shyam_Pragash]

Hi,

Same error AsEnumerable is not a member of system.Data.Datable

Thanks
Shyam

[ppr (Peter Preuss)]

@Shyam_Pragash

Hi,

getting on error

refer screen shot

Thanks
Shyam

we didn’t mention this code line

[Shyam_Pragash]

Hi,

i mentioned same error on ur colde

can u tell how to fix it.

[ppr (Peter Preuss)]

AsEnumerable is not a member of 'System.Data.Datatable'

Hi @lucas.mcgonagle EDIT 20.10 fixed this issue for newly created projects. You can fix it by adding the Assembly Reference manually in your xaml file: [image] Simply open the file in Notepad and create new line with this String: <AssemblyReference>System.Data.DataSetExtensions</AssemblyReference> Then reopen your project and the error should be gone. Please be careful while doing so and always keep a backup.

[prateek.mehandiratta9 (Prateek Mehandiratta)]

Its showing fine here, make sure you are sotring this in a integer variable.

When you put a dot after dt_Excel intellisense sould give you AsEnumerabke in the list automatically, so you donot need to type manually.

Thanks.

[Shyam_Pragash]

Hi @ppr @prateek.mehandiratta9

i able to get overall rows count in the columns : Dt_excel.Columns(“Rep”).Table.RowCount.ToString

i want to specific columns (Rep) get unique item count based the value like if value is Gill the count is 3 to print as output using write line acivity.

Thanks
Shyam

[prateek.mehandiratta9 (Prateek Mehandiratta)]

Hi,

Can you share what error you uare getting here, why isnt it working?
dt.AsEnumerable.Count(Function(r) r(“Rep”))

[ppr (Peter Preuss)]

just give a description of the expected output base on the shared input sample

@Shyam_Pragash

Sample data table

we recommend to avoid communication with too much ping-pongs

[Shyam_Pragash]

Hi,
I want to take the count of “Gill” in the “Rep” column and the same manner in the “item” column i I want to take count of “Desk”.

Columns	Item	Count
Rep	Gill	3
Rep	Smith	1
Item	Pencil	3
Item	Binder	4

I need a query to take the count. I belive I have cleared the issue.

Thanks
Shyam

[Shyam_Pragash]

Hi,

Thanks for your Support and help @ppr @prateek.mehandiratta9

i Found the Solution Code running without error. but its showing complier error is present

i thought it is bug. see snapshot

Thanks
Shyam

[prateek.mehandiratta9 (Prateek Mehandiratta)]

after AsEnumerable remove brackets.

[prateek.mehandiratta9 (Prateek Mehandiratta)]

How do you know its working as solution if its having a compilation error.