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

How to use matrix resualt from SQL Query

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

Example.

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

CityUserTotal Activity
MoscowIvanov5
MoscowPetrov1
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
Reply
1 Reply
Automation Master
Automation Master

Re: How to use matrix resualt from SQL Query

check documentation for the action http://help.nintex.com/en-US/nintex2013/help/#Workflow/RootCategory/Actions/Nintex.Workflow.ExecuteS... 

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.

Reply