Count rows on studiox

Hi.
How can I count data table rows on studioX?

1 Like

It would be great if you could provide more details about your scenario, but here are some options:

  1. Use Excel to operate on your tabular data, with the Count() function in this case
  2. Use the AdvancedEditor option, if your scenario is more advanced, and access members programmatically:
    image
1 Like

Hi @jhj3627

The .net method for retrieving the number of rows in a datatable is

datatable.Rows.Count.ToString

You can use a message box activity or writeline activity to see the value.

Please mark as solution if found useful :slight_smile:

3 Likes

Hi guys.
Thank you for your posts. It’s so usable.
But I wanted writing the datatable on project notebook and get the number of rows.
Because it’s more difficult to write datatable on excel after parameterizing than directly write datatable on excel. (I’m using extracting table data)

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