How to check SQL Data tables Row Count and need to apply condition if <1000 rows

Help Studio
, ,
1

Need help to find out rows count from SQL Query.

Process Flow:

  • Get the data from SQL and export into Excel file with naming convention.
  • Check if there is <1000 rows then need to retry SQL query and if not then need to export in
    Excel/.csv.
2

@PALKUMARI_PATEL

Hope you are using Execute Query activity to retrieve the data from Database.

If yes then it will give output as DataTable. Let’s say dtOutput. And then you can check row count as below.

                    dtOutput.Rows.Count
1 Like
3

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