Question

Can I directly get sql query response without using any loop

  • 14 February 2023
  • 2 replies
  • 194 views
A
Badge +4

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

rbkadiyam
Rank
Userlevel 5
Badge +14

@ajith 2492  You can store into variable and use it

 

Ramesh B Kadiyam
Raul Jaimes
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


Terms & ConditionsCookie settings