Welcome to the Datanyx Community!

Get Help, Learn Best Practices, Network With Other Datanyx Users
I need to change a ...
 
Notifications
Clear all

I need to change a specific group of values in a column. How do I achieve this in the workflow that I’ve created?

1 Posts
1 Users
0 Likes
259 Views
Nikhila
(@nikhila)
Member Admin
Joined: 2 years ago
Posts: 338
Topic starter  
This action replaces a particular entity with a new replace value. 
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 ‘Replace’ option from the dropdown.  
Step 4: Enter the old replace value and the new replace value. Click on the ‘Apply’ button. (Refer to the image below). 
1673439661-replace.png

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).  

1673439708-result.png
Step 7: The data is reflected based on the operations selected. (Refer to the images below). 
1673439729-replace1.png

   
Quote
Share: