Transformation

Transformation

Data transformation is the process of changing raw or messy data into a clean, organized format that’s easy to understand and ready for analysis. This step is essential to make sure the data is accurate, consistent, and useful.

During transformation, several tasks may be performed, such as:

• Removing duplicates or blank (null) values
• Correcting errors in data entries
• Standardizing formats, like converting all dates to the same structure or unifying currency values
• Validating data to ensure it meets business rules

By transforming data, you improve its quality, making it more reliable for reporting, decision-making, and advanced analytics. It also ensures teams work with trusted information so the insights they generate are meaningful and accurate.

How to Use the Transformation Feature

To apply a transformation to your data, follow these easy steps:

1. Start by creating a data source – This is where you load the input data you want to work with.
2. Open the Transformation section in the left-hand component panel to view all available transformation options.
3. Select a transformation – You can either click on a transformation to add it to the canvas or drag and drop it from the component panel.
4. Connect the data flow – Link the output node of your data source to the input node of the transformation component.