Transform Data

Updated 6 months ago by Karan

How to Transform Data in Byteline

Transform node in Byteline is used to transform data between formats in an easy way. Currently, the transform data node supports data conversion in two formats:

  • CSV to array 

Input (CSV Format)

column1,column2

value1, val2

val21, val23

Output (Array format)

[[value1, val2], [val21, val23]]

  • CSV to JSON 

Input (CSV Format)

column1,column2

value1, val2

val21, val23

Output (JSON format)

[

{

"column1":"value1",

"column2":"val2"

},

{

"column1":"val21",

"column2":"val23"

}

]

Follow the steps mentioned below to transform data in Byteline.

Create

In this documentation, a flow has already been created. For more detail about how to create your first flow, you can refer to the guide here. 

Configure 

Step 1: Click on the add button to add the Transform Data node.

Step 2: Select the Transform node from the node configuration window. 

Step 3: Click on the edit button to configure the Transform node. 

Step 4: A modal window will appear where you can configure the Transform node. 

Step 5: Select the transform data type, which can either be CSV to JSON or CSV to an array. 

Step 6: Enter the source data. 

Step 7: If you want to remove the first row, tick the remove header row checkbox. 

Step 8: Specify the columns you want to retain. 

By leaving the Columns box empty, all columns will be kept.

Step 9: Click on the Save button.

Step 10: The green color on the node indicates that the node has been successfully configured.

Your Transform node has been configured successfully. Feel free to connect us for any doubt.

How did we do?