cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
dhanashree
Nintex Newbie

extract multiple rows and columns using Execute SQL

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.

 

Labels: (1)
0 Kudos
Reply
1 Reply
Nintex Employee
Nintex Employee

Re: extract multiple rows and columns using Execute SQL

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.
0 Kudos
Reply