Supports Expression Language: true (will be evaluated using flow file attributes and variable registry)Header | validate-csv-header | true | | True if the incoming flow file contains a header to ignore, false otherwise. |
Delimiter character | validate-csv-delimiter | , | | Character used as 'delimiter' in the incoming data. Example: , Supports Expression Language: true (will be evaluated using flow file attributes and variable registry) |
Quote character | validate-csv-quote | " | | Character used as 'quote' in the incoming data. Example: " Supports Expression Language: true (will be evaluated using flow file attributes and variable registry) |
End of line symbols | validate-csv-eol | \n | | Symbols used as 'end of line' in the incoming data. Example: \n Supports Expression Language: true (will be evaluated using flow file attributes and variable registry) |
Validation strategy | validate-csv-strategy | FlowFile validation | - Line by line validation
![In case an error is found, the input CSV file will be split into two FlowFiles: one routed to the 'valid' relationship containing all the correct lines and one routed to the 'invalid' relationship containing all the incorrect lines. Take care if choosing this option while using Unique cell processors in schema definition:the first occurrence will be considered valid and the next ones as invalid. In case an error is found, the input CSV file will be split into two FlowFiles: one routed to the 'valid' relationship containing all the correct lines and one routed to the 'invalid' relationship containing all the incorrect lines. Take care if choosing this option while using Unique cell processors in schema definition:the first occurrence will be considered valid and the next ones as invalid.](../../../../../html/images/iconInfo.png) - FlowFile validation
![As soon as an error is found in the CSV file, the validation will stop and the whole flow file will be routed to the 'invalid' relationship. This option offers best performances. As soon as an error is found in the CSV file, the validation will stop and the whole flow file will be routed to the 'invalid' relationship. This option offers best performances.](../../../../../html/images/iconInfo.png)
| Strategy to apply when routing input files to output relationships. |
Relationships:
Name | Description |
---|
valid | FlowFiles that are successfully validated against the schema are routed to this relationship |
invalid | FlowFiles that are not valid according to the specified schema are routed to this relationship |
Reads Attributes:
None specified.Writes Attributes:
Name | Description |
---|
count.valid.lines | If line by line validation, number of valid lines extracted from the source data |
count.invalid.lines | If line by line validation, number of invalid lines extracted from the source data |
count.total.lines | If line by line validation, total number of lines in the source data |
validation.error.message | For flow files routed to invalid, message of the first validation error |
State management:
This component does not store state.Restricted:
This component is not restricted.Input requirement:
This component requires an incoming relationship.System Resource Considerations:
None specified.