Cloud Portal ONE Desktop ONE DQ&C ONE MDM ONE RDM ONE Runtime Server
User Community Service Desk Downloads

Edit Schema Step

Renames and reorders attributes in your data flow schema without modifying the actual data content.

This step is available for all transformation types: standalone plans, embedded plans, transformation rules, and transformation catalog items.

The Edit Schema step provides a simple UI for managing column names and their order in your data flow. This is particularly useful in data preparation workflows where you need to standardize attribute names or organize them for better readability.

Use cases

  • Improving data clarity: Rename cryptic column names (like F9, F10) to meaningful names (like customer_name, order_date).

  • Preparing for export: Ensure column names meet specific requirements or naming conventions for downstream systems.

  • Aligning data structure: Reorder columns to match expected schemas or improve logical flow.

  • Data standardization: Harmonize attribute names across different data sources before joining or merging.

Configuration

Renaming attributes

  1. In the Edit schema step configuration, you’ll see a table with all available attributes from connected input steps.

  2. Click on any attribute name in the Attribute name column to enter edit mode.

  3. Type your new attribute name. The Original name column shows the source attribute name for reference.

  4. Confirm your changes using one of these methods:

    • Click the checkmark (✓) button to save the new name.

    • Click the X button to cancel and revert to the original name.

    • Press Enter to save or Escape to cancel

  5. The interface tracks your modifications, showing the count of renamed attributes (e.g., "1 renamed") in the summary.

  6. Use the search functionality to quickly find specific attributes in large schemas.

Each attribute can be renamed independently, and the original names are always preserved for reference. You can see your progress with the change counter that updates as you make modifications.

Reordering attributes

You can reorder attributes using two methods:

Drag-and-drop reordering

  1. Use drag-and-drop functionality to reorder attributes in your preferred sequence.

  2. This method is ideal for moving attributes short distances or making quick adjustments.

Context menu positioning

  1. Select one or more attributes by checking the boxes next to their names.

  2. Right-click on a selected attribute or use the menu icon to open the positioning options.

  3. Choose from the following positioning commands:

    • To first position - Moves the selected attribute(s) to the beginning of the schema.

    • Place before attribute…​ - Positions the selected attribute(s) before a specific attribute you choose.

    • Place after attribute…​ - Positions the selected attribute(s) after a specific attribute you choose.

    • To last position - Moves the selected attribute(s) to the end of the schema.

The context menu method is particularly useful for large schemas where drag-and-drop might be cumbersome, or when you need precise positioning relative to other attributes.

The reordering affects how attributes appear in downstream steps and final outputs.

Managing changes

  1. The interface displays a summary of schema changes (e.g., "18 attributes added").

  2. Use filtering options to view specific types of changes (added, deleted, or modified attributes).

  3. Select Apply changes to commit your modifications to the data flow.

Changes made in the Edit Schema step only affect the schema structure. The actual data values remain unchanged, making this a safe operation for reorganizing your data flow.

Functional scope

The Edit Schema step is limited to:

  • Column name modifications: Rename existing attributes to more meaningful names

  • Column reordering: Change the sequence of attributes in the schema

  • Schema organization: Improve the logical structure of your data flow

This step does not:

  • Modify data values or content.

  • Add or remove attributes (use Add Attributes or Delete Attributes steps instead).

  • Perform data type conversions.

  • Apply data transformations or calculations.

See also

Was this page useful?