How to get row count of specific column name

Help
4

Hello @mohininemade301094,

You use this linq in the assignment activity to an interger variable.

DtTable.Rows.Cast(Of DataRow)().Where(Function(row) Not row.Item("ColName") IsNot DBNull.Value Or row.Item("ColName").ToString() <> "").Count

Regards
Balamurugan.S

12 Likes