Welcome to the Datanyx Community!
Get Help, Learn Best Practices, Network With Other Datanyx Users
Notifications
Clear all
Topic starter
05/01/2023 9:23 am
The user is able to apply transformation to one or multiple columns in a dataset.
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. (Refer to the image below).
Step 3: Once a successful connection is made between ‘data import and data transformation’, click on the select button. A pop-up appears with the columns present in the data.
Step 4: Columns can be filtered on various options available. Individual columns can also be selected for filtering.
Step 5: Click on ‘Apply’. (Refer to the image below).
Step 6: Click on configure to make changes to the data. A data transformation pop-up appears. Choose the columns that need change by clicking on the dropdown. (Refer to the image below).
Step 7: Once the data configuration has been done, click on the run button or the data transformation node twice to run the workflow.
Step 8: Click on the icon in the bottom line. (Refer to the image below).
Step 9: In the example below, “Units_Sold” has been renamed as “Unit Sales”. The data is reflected based on the operations selected. (Refer to the images below).
Note: The user can run the workflow for individual nodes as well.