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

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.

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

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.

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.