This section provides an example of how you can use the Python collection and processing agents for a batch workflow. In this instance the Python collection agent reads an Excel file. 

Open

Workflow example with the Python collection and processing agents for batch

Open

The Excel file being processed

Workflow Configuration

The sections below provide descriptions of agent configurations for the example workflow shown above.

Read_Excel

The Python collection agent is configured to read all the Excel files from the configured directory, process each file in a separate batch and output one UDR per row.

General Tab

MIM Tab

The agent publishes Filename as a string.

Analyse_Rows

The Python processing agent processes UDRs by defining a consume block, and uses the selected Interpreter profile that is used to configure the Python executables.

Workflow Monitor

The output is shown step by step in the workflow monitor when you have debug enabled.

Workflow Monitor showing the output for both agents