Data Transformation
Transforming data is the process of shaping your data into a usable format. Instead of using different individual tools to modify your data, you can do it in the Automation module thanks to its capability of data transformation and use its outcome at once.
Contents
-
Introduction to data transformation
Learn how to modify files and import them to Synerise through Automation
-
Creating transformation rules
Learn how to build a data transformation diagram
-
Transformations and data operators
-
"Data Input" node
Use this node to upload a file to be modified
-
"Add column" node
Add a column in a file with values in the rows
-
"Remove columns" node
Remove unnecessary columns out of your data
-
"Enrich with Catalog" node
You can transform data by enriching it with information you have in a Synerise catalog
-
"Merge columns" node
Combine the values from various columns into one value
-
"Rename columns" node
Change the name of the columns in an uploaded file
-
"Edit values" node
Use this action in data transformation to suffix, prefix, and replace column values
-
"Filter rows" node
Use this node to select or exclude particular rows in the file
-
"Reorder columns" node
Change the order of columns or values in a column
-
"Regex Replace" node
Use regular expressions to edit the values in the rows of the sample file
-
"Encrypt Data" node
You can encrypt column values with RAS or AES encryption keys created in Synerise
-
"Decrypt Data" node
You can decrypt column values with RAS or AES encryption keys created in Synerise
-
"Data Output" node
The final node which you add to the transformation to see the results
-
