Data Filter component RRTs

Component RRT ID

The RRT ID for this component is DFT.

Date and time related RRTs are evaluated in Coordinated Universal Time (UTC) by default. It can be set to use local time, for more details, see Using RRTs.

Reserved Replacement Tag Names (RRTN)

This component generates the following RTN values.

Name Description
FileCount The number of documents in the job.
FileSize The size of the first file in the batch in Kb.
FileSize,Index The size of the file of index Index in Kb.
FileSize,* The sizes of all files in Kb concatenated into one string separated by comma.
FileName The name of the first input file.
FileName,Index The name of the file by index.
FileName,* The names of all files concatenated into one string, separated by comma.
FileExt The extension of the first input file.
FileExt,Index The extension of the file, by index.
FileExt,* All the extensions of the input files concatenated into one string, separated by comma.
ValidationResult

If the Validate filter detects invalid metadata, this RRT is replaced by the error message configured in this filter. Ifany other error occurs at run time, this RRT is also replaced with an error message corresponding to this error. If no errors occur at run time, this RRT is replaced with the "Success" value.

This RRT may be used in the components like Workflow Tracker or Notification Options to get the information about processing result.

Field Replacement Tag Names (FRTN)

This component generates the following FRTN values.

Name Description
% field name % This RRT is replaced with the value generated by a particular filter. Field name is the value of the Field name parameter specified in the filter's configuration. The description of this RRT replacement for a particular filter can be found in the chapters describing the filters.
%field name%,N This RRT is replaced with the value generated by Split or Parse CSV filters. Field name is the value of the Field name parameter specified in the filter's configuration, N index is replaced with the position number of a split part or a CSV field correspondingly.
%field name,Column name% This RRT is generated by the Lookup in DB filter and is replaced with the list of the output values for a Column name column. Field name is the value of the Field name parameter specified in the filter's configuration.
% field name # IsSuccess % This Boolean RRT is used in the Validate filter for validation of the result of Match Regular Expression, Starts With, Ends With, Equals To, or Contains filter. It is replaced with TRUE if the filter operation ends with success. Otherwise, it is replaced with FALSE. 
% field name # IsFailure % This Boolean RRT is used in the Validate filter for validation of the result of Match Regular Expression, Starts With, Ends With, Equals To, or Contains filter. It is replaced with TRUE if the filter operation ends with failure; otherwise, it is replaced with FALSE. 
% field name # IsInvalidDate % This Boolean RRT is used in the Validate filter for validation of the result of the Format Date filter. It is replaced with TRUE if the input string is not a valid date. Otherwise, it is replaced with FALSE. Field name is the value of the Field name parameter specified in the Format Date filter's configuration.
% field name # IsInvalidtime % This Boolean RRT is used in the Validate filter for validation of the result of the Format Time filter. It is replaced with TRUE if the input string is not a valid time. Otherwise, it is replaced with FALSE. Field name is the value of the Field name parameter specified in the Format Time filter's configuration.
% field name # DoesNotExist % This Boolean RRT is used in the Validate filter for validation of the result of the Lookup in DB filter. It is replaced with TRUE if there are no records in the result set. Otherwise, it is replaced with FALSE. Field name is the value of the Field name parameter specified in the Lookup in DB filter's configuration.
% field name # Exists % This Boolean RRT is used in the Validate filter for validation of the result of the Lookup in DB filter. It is replaced with TRUE if the result set contains one or more records. Otherwise, it is replaced with FALSE. Field name is the value of the Field name parameter specified in the Lookup in DB filter's configuration.

See the examples of the RRT usage in the descriptions of the certain filters.

Special Set Replacement Tag Names (SSRTN)

This component does not support any SSRTN values.