Skip to main content
Question

How to retrieve a database record count and save it to a variable

  • June 9, 2023
  • 2 replies
  • 359 views

Forum|alt.badge.img+3

Is it possible to return a database record count and save that number to a variable? It seems very simple but I can’t find any documentation that explains how to do that. 

2 replies

rbkadiyam
Premier Pathfinder | Tier 7
Forum|alt.badge.img+17
  • Premier Pathfinder | Tier 7
  • June 13, 2023

@Eddie Pequeno  execute select query and store output as variable (checkbox option)


Forum|alt.badge.img+4
  • Navigator | Tier 3
  • July 25, 2023

1) Database:Use export to datatable- select query and save Output to table variable

2) Datatable: get no of rows 

 

Thanks,

Aravindh s

Aravindhkumar002@gmail.com