Welcome to the Datanyx Community!
Get Help, Learn Best Practices, Network With Other Datanyx Users
Notifications
Clear all
Topic starter
10/01/2023 12:29 pm
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).
Step 2: Click on the configure button. A pop-up appears. Click on template. (Refer to the image below).
Step 3: An excel file will be downloaded. Open the file. Click on sheet 1. Here, the user is able to perform different actions to multiple datasets at a time. (Refer to the image below).
Step 4: Enter the dataset name, field name and the actions. Save the file. (Refer to the image below).
Step 5: Now, click on upload and choose the saved file. Click on the next button. (Refer to the image below).
Step 6: From the pop-up that opens, select the dataset (original table name).
Step 7: Click on the dataset name and ensure that the check box has been selected.
Step 8: The changes made in the excel will have been updated. Click on ‘Apply’. (Refer to the image below).
Step 9: Click on the output dropdown and select the data source. Enter the prefix and suffix for the data source. (Refer to the image below).
Step 10: Now, the table containing the configured data is stored in the destination database.