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.
Can I work with this matrix? Or I need make 3 Nintex Actions for each data type and work with 3 collections?
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.