Workflow Control

 

Workflow

A Workflow is a user defined series of steps that performs integration, automation, and analytic oriented tasks.

Workflow Execution can be manipulated dynamically via Workflow Control actions.

Workflows can be designed to execute in nonlinear orders with Jumps and For Each Loops.

Actions
workflow control actions

Jump To

Required Parameters:

  • Jump To

Description:

The Jump To action jumps to the Jump To workflow step when executed.

How to Add a Jump To Action
Step Description

1

Add a Conditional Jump To action.

2

Check Jump To

3

Select the Workflow Step to jump to.

4

Click OK.

Conditional Jump To

Required Parameters:

  • Var
  • True Branch
  • False Branch

Description:

The Conditional Jump To action evaluates a Boolean Variable and either branches to the True or False Workflow Step.

How to Add a Conditional Jump To Action
Step Description

1

Add a Conditional Jump To action.

2

Check Conditional.

3

Select a Boolean Variable for Var.

4

Select a Workflow Step to branch to when Var is True.

5

Select a Workflow Step to branch to when Var is False.

6

Click OK.

Empty Group Jump To

Required Parameters:

  • Group
  • True Jump
  • False Jump
  • Group Not Defined
  • Group Empty

Description:

The Empty Group Jump To action determines if a Group is not defined and/or is empty and jumps to corresponding branch.

If a Group is not defined and/or is empty the action will jump to the True branch.

How to Add an Empty Group Jump To
Step Description

1

Select a Working Data collection or HyperCube.

2

Check Group Not Defined if you wish to test if the group exists.

3

Check Group Empty if you wish to test if the group is empty.

4

Select a True Workflow Step to jump to.

5

Select a False Workflow Step to jump to.

6

Click OK.

For Each

Required Parameters:

  • Foreach Group

Description:

The For Each action performs a For Each loop through a Working Data collection.

For each row in the Working Data collection, the row is copied as a set of Variables.

The For Each action is accompanied by an End Foreach Conditional Jump To action that jumps back to this action.

Each time the workflow jumps back to this action, the Variables are cleared and the next row is instantiated as a set of Variables.

The For Each action is responsible for iterating to the next row and instantiating that row as a set of Variables.

The End Foreach Conditional Jump To action is responsible for determining if the end of the group has been reached. When False, the action will jump to the For Each action. When True, the workflow will continue to the next step.

How to Perform a For Each Loop
Step Description

1

Add a For Each action.

2

Select the Working Data collection you wish to perform a For Each loop on.

for-each-how-to-3
for-each-how-to-4

3

Add a Conditional Jump To action.

Check End Foreach

Select the For Each loop created in Step 1.

for-each-how-to-5
for-each-how-to-6

4

Click OK.

Running the action...

for-each-how-to-2

Note - Right clicking and hitting Run Selected on the For Each action will iterate to the next row.

Delay Execution

Required Parameters:

  • Number of Seconds to Delay

Description:

The Delay Execution action delays the execution of a Workflow for a specified number of seconds.

How to Delay the Execution of a Workflow
Step Description

1

Enter a Number of Seconds to Delay.

2

Click OK.

Stop Execution

Required Parameters:

  • None

Description:

The Stop Execution action stops the execution of a Workflow.

How to Stop the Execution of a Workflow
Step Description

1

Select the Stop Execution button to add the action to the workflow.

There are no inputs for this action.

Hint - This action is generally used in conjunction with a Conditional Jump To or Empty Group Jump To action.

Detect Different Data

Required Parameters:

  • Original Group
  • New Group
  • Identical Data
  • Different Data

Description:

The Detect Different Data action compares two Working Data collections and determines if they are different from one another.

How to Detect Different Data
Step Description

1

Select a Working Data collection as the Original Group.

2

Select a Working Data collection as the New Group.

3

Select an action in the event of Identical Data.

  • Return Error
  • Return Success
  • Stop Workflow
  • Set Variable

4

Select an action in the event of Different Data.

  • Return Error
  • Return Success
  • Stop Workflow
  • Set Variable (isDifferent)

5

Click OK.

Database Wait Condition

Required Parameters:

  • Working Data
  • Data Point

Optional Parameters:

  • Replace With

Description:

The Replace Values action replaces each value in the targeted Data Point with a specified input or sets the Data Point to null.

How to Replace Values in a Data Point
Step Description

1

Select the Working Data collection that contains the targeted Data Point.

2

Select the targeted Data Point.

3

Input a new value or leave Replace With blank for a null value.

5

Click OK.