Welcome to the Datanyx Community!

Get Help, Learn Best Practices, Network With Other Datanyx Users
I have imported dat...
 
Notifications
Clear all

I have imported data and I need to remove special characters from select columns. How do I achieve this?

1 Posts
1 Users
0 Likes
272 Views
Nikhila
(@nikhila)
Member Admin
Joined: 2 years ago
Posts: 338
Topic starter  

Step 1: Once data is imported, click on data preparation. (Refer to the image below).

1671708138-datapreparation.png
Step 2: Drag and drop ’Cleansing node onto the main screen. Connect the two nodes. (Refer to the image below).  
1673502508-cleansingdp.png

Step 3: Once a successful connection is made between ‘data import and cleansing’, click on the select button.  

Step 4: A cleansing pop-up appears with the columns present in the data. Click on ‘Apply’.  

Step 5: Columns can be filtered on various options available in the right panel. (Refer to the image below).

1677050937-cleansingdp1.png
Step 6: Once the columns and the operations that need to performed have been selected, click on the run button or the cleansing node twice to run the workflow. Click on the icon in the bottom line. (Refer to the image below). 
1671708343-result.png
Step 7: The cleansed data is reflected in the form of a table. (Refer to the image below).
1671708375-cleansingdp2.png
Note: The user can run the workflow for individual nodes as well.

   
Quote
Share: