Skip to main content
Nintex Community Menu Bar

Execute SQL - Multiple columns

  • October 12, 2015
  • 2 replies
  • 35 views

Forum|alt.badge.img+2

I have the following scenario:

 

Select EmployeeName, Phone, Email from Emplyees

 

The action places the results in a collection, which appears to be single dimensional. How do I access the other columns?

 

Please let me know if further clarification is needed.

 

Thanks in advance!

2 replies

Forum|alt.badge.img+2
  • Author
  • October 12, 2015

Thank you, that was helpful. I was able to put the other columns in separate collection variables. Now, when I run a For Each loop for the first column, how do I access the value from the second column with the same index?

For example, I'd like to read through a SQL table with 3 columns and insert the rows in a SharePoint list.

Thank you,


Forum|alt.badge.img+2
  • Author
  • October 12, 2015

Thank you!