Showing results for 
Search instead for 
Did you mean: 
Nintex Newbie

How to use matrix resualt from SQL Query

LF best practice. How can I work with matrix result from SQL Query action?


A have SQL action in my workflow. As result of query I have matrix.

CityUserTotal Activity
St. PetersburgSidorov4

Can I work with this matrix? Or I need make 3 Nintex Actions for each data type and work  with 3 collections?

0 Kudos
1 Reply
Automation Master
Automation Master

Re: How to use matrix resualt from SQL Query

check documentation for the action 

since your query returns more then 1 column you have to check 'Specify column names' and it wil allow to specify a collection variable for each column.

then you will have to use 'For each loop' action to loop through collection(s) to process data.