Splitting Transformation

Split a single table into multiple tables by selecting specific columns for each resulting table.

To split a transformation:

1. Navigate to the transformation view and click the Plus icon.
2. Select Split from the menu options.
3. Enter the following details for the first table:
   • Transformation Name
   • Description
   • Table 1 Name
   • Select the desired columns for Table 1
4. Click Add More to configure additional tables.
5. For the second table:
   • Enter Table 2 Name
   • Select the columns to include in Table 2
6. To finalize the split:
   • Click Save to complete the transformation
   • Click Add More to create additional tables
   • Click Save to apply all configurations
   • Click Cancel to discard the transformation

Once completed, the table will be split according to the specified configuration.