Skip to main content
Nintex Community Menu Bar

extract multiple rows and columns using Execute SQL

  • August 12, 2019
  • 1 reply
  • 20 views

Forum|alt.badge.img

Hi All,

 

I wanted to know if there is anyway to extract multiple rows and columns using execute sql action.Further, I would want to export the results as an excel sheet.

Please help.

 

1 reply

Simon Muntz
Nintex Partner
Forum|alt.badge.img+23
  • Nintex Partner
  • August 13, 2019
Hi,
The Query SQL action allows you to select columns that you want to capture so you can have a collection variable for each column.

To update an excel sheet you would have to use the Document Generation action as the Query Excel action does not allow for updates.