Welcome to the Datanyx Community!

Get Help, Learn Best Practices, Network With Other Datanyx Users
The datasets that I...
 
Notifications
Clear all

The datasets that I’ve imported to the workflow need to be configured. How do I do this to multiple datasets?

1 Posts
1 Users
0 Likes
251 Views
Nikhila
(@nikhila)
Member Admin
Joined: 2 years ago
Posts: 338
Topic starter  
The user is able to apply transformation to the columns from a list of selected datasets.  
Step 1: Click on transformation. Drag and drop the bulk data transformation node onto the main screen. Select the data source by clicking on the ‘Select a Data Source’ dropdown. (Refer to the image below).  
1673264705-bulkdatatransformation.png
Step 2: Click on the configure button. A pop-up appears. The user is able to upload a file from the local device. Click on skip to manually configure the datasets. (Refer to the image below). 
1673264741-bulkdatatransformation1.png

Step 3: Once the skip button has been clicked, the user is able to see another pop-up screen.  

Step 4: Here, you can select the sheet required and make the necessary changes to the columns in the selected sheet. The user can make changes to multiple columns at a time by clicking on the actions available. 

Step 5: Once the configuration required is selected, click on the ‘Apply’ button.(Refer to the images below).  

1673264774-bulkdatatransformation2.png
1673264792-bulkdatatransformation3.png

Step 6: Click on the filter button to filter the data further or click on the output dropdown and select the data source.  

Step 7: Enter the prefix and suffix for the data source. (Refer to the image below).  

1673264822-bulkdatatransformation4.png

Step 8: Once the data source has been selected, click on the run button or click on the bulk data transformation node twice to run the workflow.  

Step 9: Click on the icon in the bottom line. (Refer to the image below).  

1673264854-result.png
Step 10: When the changes are successful, the user will get the table in the image below under the result tab. (Refer to the image below). 
1673264892-bulkdatatransformation5.png

Step 11: Now, the table containing the configured data is stored in the destination database. 


   
Quote
Share: