Skip to main content
Question

Can I directly get sql query response without using any loop

  • February 14, 2023
  • 2 replies
  • 299 views
A
Forum|alt.badge.img+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
Premier Pathfinder | Tier 7
Forum|alt.badge.img+17
  • rbkadiyam
  • Premier Pathfinder | Tier 7
  • February 14, 2023

@ajith 2492  You can store into variable and use it

 

Ramesh B Kadiyam
Raul Jaimes
Forum|alt.badge.img+9
  • Raul Jaimes
  • Navigator | Tier 3
  • February 14, 2023

@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

A
Terms & ConditionsCookie settingsAccessibility statement