Welcome to the Datanyx Community!
Get Help, Learn Best Practices, Network With Other Datanyx Users
Notifications
Clear all
Topic starter
10/01/2023 12:39 pm
Override is used to truncate an existing dataset/ table from the database and write the current workflow table.
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 ‘Override’ radio button. (Refer to the image below).
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: 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.