Table Management in Workflow Creation:

Overview:

The Table component in workflow creation allows users to create and configure custom tables to store and manage output data from workflows. This guide provides a detailed overview of how to use the Table component, including table configuration, field mapping, and setting primary keys.

Steps to Create and Configure a Table:

1. Adding a Table Component

• During workflow creation, add a Table component.
• Click on the Table component to navigate to the custom table configuration screen.

1. Table Configuration Screen

• The right-side panel displays two sections: Table Settings and Select Fields.
• By default, the Table Settings section is displayed.

1. Table Settings Section

• Table Name: Enter a unique name for the table (mandatory).
• Table Description: Provide a description for the table (optional).
• Record Creation Type: Select from the dropdown options: Upsert, Replace, or Append.
  • Upsert: Insert or update records.
  • Replace: Replace existing records. (Mark All records are deleted when new records are added)
  • Append: Add new records to the table. (Each record will be unique due to timestamp added to all records)

1. Select Fields Section

• Selected transactions will be displayed with output values in a dropdown.
• Users can expand and view the output values.
• Users can map these output fields to the table either one by one or all at once by dragging them to the table.

1. Field Mapping and Configuration

• Users can drag the output fields to the table. The table will display the field name and data type.