Editor
The Editor function offers a wide range of tools to help you modify and work with different data types, such as text, numbers, and special characters.
Each category—like strings, numbers, or unique characters—has operations designed to handle everyday tasks. You can use it to:
- Format or clean up text (e.g., trim spaces, change case)
- Perform numeric calculations
- Extract or replace specific characters
- Apply advanced editing logic as needed
It’s a flexible tool that allows you to fine-tune your data before moving it to the next step in your workflow.
How to use Editor?
Step 1: Connect the Editor to the step and open it by clicking on it.
Step 2: Derived Columns
Add a new derived column using the “+” icon.
Step 3: Derived Column Name
- Here, the user can provide the name of the newly derived column.
Step 4: Write the Expression
- This is the core area where users build their formula or logic to create the new column.
- Tabs available:
-
- Fields: Lists all available fields you can use (e.g., Brand, Base_Price_Rs)
- Functions: Gives predefined functions (like UPPER(), IF(), CONCAT(), SUM() etc.) for transformation.
Step 5: Click “Validate & add” to validate the expression and add it to the derived column. Similarly, users can create and add more columns.
Step 6: Users have the option to edit and delete the expression of the derived column.
Click “Save.”
For example:
- Start by adding a derived column and entering a name. In this example, we named it “Total Brand” in the “Column Name”
- Select the “Function” as count and choose “Brand” as the “Field” to calculate the total number of brands. Use these selections to write the expression.
- Click “Validate & add” to confirm and apply the expression.
- Next, we created another derived column named “Uppercase_Style”.
- For this, select the “Function” upper and choose “Style” as the field. This will convert all style names to uppercase.
- Again, “Validate and add” the expression to complete the step.
Preview
