How to get row count of specific column name

Help
3

Hi @mohininemade301094,

Good, so kindly use this method,
you will be having a name for datatable , say “dt_1”

  1. Inside for each row loop, mention the datatable name, with for each row loop variable name “rows”
  2. say you want to know the total row count (ignoring empty rows) of second column, with index 1, use a if condition mentioning, Not String.IsNullOrEmpty(rows(1)). or you can mention even column name instead of index like Not String.IsNullOrEmpty(rows(“ColumnName”))
  3. Use a counter with assign activity, that adds 1 to the counter if the above condition get satisfied.
  4. Thus that counter gives you the total row count ignoring the empty rows…

Cheers…

You will be getting row count.

3 Likes