How to calculate column row count if columns are of different lengh

[Mathkar_kunal]

Hello,

I need to calculate manager list and resource list colums row coiunt.
check below ss

how can i calculate?
i checked with CurrentRow(“Resource List”).Tostring.Length this formula but giving count for manager as o and resource list as 6 which is wrong.
help me with same.

[Gokul001 (Gokul Balaji)]

Hi @Mathkar_kunal

Can you try with this expression

Int32Variable = Dt.Rows.Cast(Of DataRow)().Count(Function(row) Not row.IsNull("Column name"))

Regards
Gokul

[arjunshenoy]

Hi @Mathkar_kunal

Please try the following expression:

managerCount = yourDataTable.AsEnumerable().Count(Function(row) Not row.IsNull("Manager List"))

Similarly, you get the Resource List count as well.

Hope this helps,
Best Regards.