Help with loop -

[timothy.mullady]

Hello,

I currently have a process that Connects to a db, Runs a query, and builds a datatable. Two fields in the datatable output need to set variables inside a loop.

Can someone help me select the appropriate loop and set the variables? Each row in the datatable is setting the variables.

thanks,

tim

[jose.ordonez1 (Jose Ordonez)]

Hi tim,
Please check the image below:

Hope it helps you!

[pikorpa (Piotr Kołakowski)]

Hey @timothy.mullady
Here’s a simplified visual representation of workflow :

• Database Connect → Connect to your DB
• Execute Query → Store results in dtResults
• For Each Row in DataTable (dtResults)
  • Assign (variable1 = row("FirstColumnName").ToString)
  • Assign (variable2 = row("SecondColumnName").ToString)

etc.

[postwick (Paul)]

You don’t need to set variables. Just use CurrentRow(“ColumnName”).ToString to get the values inside the loop (For Each Row in Data Table).

Connects to a db, Runs a query, and builds a datatable

The query activity returns a datatable, you don’t have to build the datatable.