Enable Advanced Settings
|
Enable the advanced options to change existing data.
The advanced settings on the second tab are ignored if the checkbox is unchecked
|
Variables to use as key values
|
From this selection box, select the variable name(s) to treat as the key value(s) when advanced record handling is specified.
|
|
Duplicates records by key value(s)
|
From this drop-down list, select how duplicate records identified by key value(s) are handled in the database. The choices are listed below:
|
Insert
|
Insert cases irrespective of whether duplicates are present in the database table. This option will not handle duplicates in the source spreadsheet. Use the Filter duplicates node prior to the Write Spreadsheet node to remove duplicates from the spreadsheet before writing to the database if that is a concern.
|
Keep
|
Keep the rows that are already present in the table and do not add the duplicate cases from the spreadsheet.
|
Update
|
Update the rows in the table to match the cases from the spreadsheet (all columns will be updated).
|
|
Unmatched records by key value(s)
|
From this drop-down list, choose how records that do not match by key value(s) are handled in the database from the options below.
|
Keep
|
Leave the rows in the table.
|
Delete
|
Remove the rows from the table.
|
Create SQL log
|
Select this checkbox to create a report of the SQL command(s) that were used to update the database.
- The log will be output as a workspace reporting document per current tool/options/document/workspace settings.
- Queries will only be logged when using selections that update data already present in the database table.
- For instance, when choosing the Drop and recreate or Truncate and insert options, the queries will not be logged, since the existing table was completely overwritten.
|