CSV Validate Header writing documents to output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-02-2021 01:29 PM
A bit of help appreciated. I am trying to accomplish this with my pipeline:
- Use File Reader and CSV parser to read a CSV file.
- With the CSV Parser, validate the file and make sure the required headers exist.
- If the headers exist, do further processing on the file. If not, do not process the file further.
I have the CSV Parser set up with the required headers and the “Contains Headers” and “Validate Headers” option enabled. When I validate the pipeline I get an exception to the error view of the CSV parser (which is what I want), but the CSV Parser is also writing the records to the output. Any way to change this?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-02-2021 07:26 PM
Hi jervin,
Please uncheck “Contains Headers” check box and set skip line =1 (assuming first line of file contains header information )
Please find the attachment for sample pipeline and row file which used as input or sample pipeline.
Regards,
Ajay
name.txt (51 Bytes) testCSVHeader_2021_02_03 (1).slp (3.9 KB)
