Transform Node: Transform the Data Before Loading It Into an Output

Use a Transform node to manipulate data based on the transformations added to the node. You can add one or more transformations to each Transform node. For example, you can add transformations to concatenate two columns, standardize the formats in a date column, and detect the sentiments of comments in a feedback column. Each transformation modifies the data in a unique way. To manipulate data at multiple stages of a data transform, add a separate Transform node at each stage.

1. In the batch data transform, select the Add Node button () between two nodes or at the end of the batch data transform. To show the Add Node button between two nodes, hover the cursor on the connecting line.
2. In the Add Node dialog box, select Transform.
   
3. In the Preview tab of the details section, select one or more columns for which you want to transform their data.
4. Use the Transform toolbar (1) to add a transformation based on the selected column(s). Each time you add a transformation to the Transform node, it appears in the left panel (2). We refer to each card in the left panel as a step.
   
5. To preview the results of a transformation in the Preview tab, select the step in the left panel.
   
6. To view the canvas, click the Collapse button ().
7. If needed, select a node in the canvas to preview the results of the node. It’s always a great idea to preview results to ensure that each node and transformation returns expected results.
8. If needed, add more transformations to the Transform node.
9. Save the batch data transform.