Welcome to the Datanyx Community!
Get Help, Learn Best Practices, Network With Other Datanyx Users
Notifications
Clear all
Topic starter
10/01/2023 12:46 pm
This is used to update a single or multiple columns of a table/ dataset. The user needs to give a primary key (can be multiple keys) which specifies the location of update.
Step 1: Create a new workflow.
Step 2: Select the data import node. Drag and drop the node onto the main screen.
Step 3: Select the data source and the data set.
Step 4: Now, drag and drop the output node that is under data onto the main screen.
Step 5: Connect the ‘data import and output’ node. Click on the ‘Update’ radio button.
Step 6: Select the data source or connectors. Enter the dataset name (name of the destination file) in case data source is selected. In case connectors radio button is selected, select a connector, choose the file type, enter the folder and file name. (Refer to the image below).
Step 7: Click on the select button to select a primary key. A pop-up appears. Choose the primary key. This should contain unique values. Click on ‘Apply’. (Refer to the image below).
Step 8: Click on the update button, you can see that a pop-up appears. Select the column(s) that you want to update. Click on ‘Apply’. (Refer to the image below).
Step 9: Now, the table containing the configured data is stored in the destination database.
Note: The user can run the workflow for individual nodes as well.