RemoveByKey

The RemoveByKey Import Header Command instructs the iSite File Processor to erase any existing records in the destination table that match the RemoveByKey parameters.

When using this option, the iSite File Processer will NOT import any records into the destination table.

Header Command Line Format

options:removebykey=<FieldName> * ;tablename=<Table name from table import spec>;version=<Version from table import spec>

Limitations

The RemoveByKey Import Header Command cannot be combined with any of the following commands:

Overwrite
Append
ReplaceByKey
FinancialMonthMapping

* Refer to the specific Data Import File Specification to see what Fields are available to be used with the ReplaceByKey option.

Page ID:4524-4417-9959