Run Time and File Location setting:

• Report Date: To configure the report date, double-click the "Date & Time Configuration" component.

• Output Folder: To set the output location, browse for a folder within the "Create folder" node.

Input File Configuration:

• Select Destination: Select the location and name for the final, consolidated report.

• Purpose: All six component reports will be automatically merged (concatenated) into this single file.

Process:

How to Run the Workflow Choose one of the following methods to execute the process:

• Using Keyboard Shortcuts:

  1. Press CTRL + A to select all nodes.

  2. Press F8 to reset the workflow.

  3. Press F7 to execute all nodes.

• Using the Interface:

  1. Select the "Main Workflow" metanode.

  2. Click the "Reset" button.

  3. Click the "Execute" button.

Process Steps The workflow executes the following four stages in order:

1. Input Data Cleaning: Cleans the raw input data, extracting two columns: Vendor IDs and Customer IDs.

2. ISP Automation: Executes Python scripts to automate tasks on the ISP, generating and exporting six separate reports.

3. File Conversion: Converts the six generated reports from .csv format to .xlsx format.

4. Report Consolidation: Merges all six .xlsx reports into a single, final output file at the specified destination.

Related Parties Process

Python Libraries Required:

• pandas: Used for data manipulation and analysis (e.g., handling the input table).

• pywin32: Provides the win32com.client module for automating Windows applications.