Welcome to the Datanyx Community!

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

I need to add data to the existing table in a workflow. How do I do this?

1 Posts
1 Users
0 Likes
184 Views
Nikhila
(@nikhila)
Member Admin
Joined: 2 years ago
Posts: 338
Topic starter  
The append feature helps the user to write new rows and tables below the existing table rows in the database.  
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. (Refer to the image below).  
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 ‘Append’ radio button. (Refer to the image below). 
1677047556-OPappend.png
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). 
1677047573-OPappend1.png
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.

   
Quote
Share: