Welcome to the Datanyx Community!

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

I need to add a prefix to the data present in a particular column. How do I do this?

1 Posts
1 Users
0 Likes
208 Views
Nikhila
(@nikhila)
Member Admin
Joined: 2 years ago
Posts: 338
Topic starter  
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 ‘Prepend’ option from the dropdown.  
Step 4: Enter the prepend value and click on the ‘Apply’ button. (Refer to the image below). 
1673439942-prepend.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).  

1673439972-result.png
Step 7: The data is reflected based on the operations selected. (Refer to the images below). 
1673439992-prepend1.png

   
Quote
Share: