How to get the number of rows in a particular Column in Datatable

[Viswanathan_M]

Suggest a expression to get it

[Palaniyappan (Forum Leader)]

Hi

Welcome to UiPath community

Hope this would help you

TestDt.AsEnumerable().Select(Function(x) x.Field(Of String)(“YourColumnName”).Trim).ToArray().Where(Function(y) Not String.IsNullOrEmpty(y)).ToArray().Count

Cheers @Viswanathan_M

[arjunshenoy]

Hi @Viswanathan_M, welcome to the Community.

You can convert the specified row into an array and take the count of the elements, which gives the number of rows present in the column.

dt.AsEnumerable().Select(Function(row) row("Column1")).ToArray().Count()

Hope this helps,
Best Regards.

[supermanPunch (Arpan)]

Hi @Viswanathan_M ,

Ideally all the columns in a Datatable will have the same row count, So we directly use the below :

DT.Rows.Count

But if the intention is to get only the Non-Empty rows Count in a column, then we can use the below Expression :

DT.AsEnumerable.Where(Function(x)Not(String.IsNullOrWhiteSpace(x("YourColumnName").ToString))).Count

The above is also when you only have empty values in the end of the column.

[Viswanathan_M]

Got the Solution its working fine Thanks Palaniyappan.

[Palaniyappan (Forum Leader)]

Glad it got resolved @Viswanathan_M

[Viswanathan_M]

I am interested in Learning this expression, from where did i learn this expression.

[Palaniyappan (Forum Leader)]

Have a view on this for more details on accessing datatable

All about Datatable - UiPath

Hi All, Datatable - variable type is the most commonly used variable type by all UiPath users And it’s been the most often asked queries in forum especially on its manipulation So I would like to have this post as a repository for those who are looking for expressions related to Datatable Let’s go one by one keeping dt as name of datatable variable 1. Get number of rows in a datatable dt dt.Rows.Count (output - int32 type) 2. Get number of columns in a datatable dt dt.Columns.Count (output…

Cheers @Viswanathan_M

[KalpeshPalav]

Hi @Palaniyappan

Thanks for providing solutions on forum.
This expression is not working for empty rows in data table, mean count 0 it’s not working.

Regards,

[Palaniyappan (Forum Leader)]

First check whether the datatable has records in it before using the linq query with a simple IF condition

@KalpeshPalav

[KalpeshPalav]

have to check only if that particular column has records. because other columns having records and hence data table will obviously say that has records.