Welcome to the Datanyx Community!
Get Help, Learn Best Practices, Network With Other Datanyx Users
Notifications
Clear all
Topic starter
11/01/2023 1:21 pm
Expressions are used to perform mathematical operations on the columns.
The syntax is as follows in the case of multiplication:
@Column_name*2
Step 1: Once data is imported, click on transformation.
Step 2: Drag and drop the data transformation node onto the main screen. Connect the two nodes.
Step 3: Click on configure to make changes to the data. A data transformation pop-up appears. Select the columns that need change and choose the ‘Expression’ option from the dropdown.
Step 4: Enter the expression value. Click on the ‘Apply’ button. (Refer to the image below).
Step 5: Once the data configuration has been done, click on the run button to run the workflow.
Step 6: Click on the icon in the bottom line. (Refer to the image below).
Step 7: The data is reflected based on the operations selected. (Refer to the images below).
