Question

Can I directly get sql query response without using any loop

  • 14 February 2023
  • 2 replies
  • 35 views

Badge +3

Hi,

I want to execute an sql select query, which will return a single value and use that value for the next step in automation. Can I directly get that value after the query execution or store that value in a variable.


2 replies

Userlevel 5
Badge +9

@ajith 2492  You can store into variable and use it

 

Userlevel 5
Badge +9

@ajith 2492

Use Database: Export to data table to get the result in a table.

 

If you query returns only one row and  one column you can store the value like below or assign it to another variable.

 

HTH

Regards

Reply