Predecessor

Goal: Setup a workbook formula that pushes the data into the database and then append more data in the same table(use the given connection string).

Input: Download table with data from here.

Connection String: Data Source=(local)\SQLEXPRESS;Integrated Security=True;User ID=SheetKraft;Initial Catalog=testdb1
Table Name: "dbo"."product"

Hint:

  1. Use the UI ExportToDatabase.SK, connect to the relevant datasource using above given connection string.
  2. Search for the given table by clicking on Table Name [horizontal dotted button].
  3. Select the relevant Operation, eg: "Table Replace".
  4. Check the columns to be exported.
  5. You can also check the output checkbox (for any column) if you want see the uploaded data.
  6. Now, select the other data that need to be processed after the first export.
  7. Use the ExportToDatabase.SK UI again and click on the Predecessor checkbox and provide a link to the formula of the first Export to database.
  8. Now, in the same table push the data (use the "Update or Insert" operation).