Check that csv-header is correct

Question

Please help me understand this thing. How organize check for correct of CSV-file header in NIFI.

I'm waiting CSV with header "c1, c2, c3". But I received the file with header "c2, c3, c4"

Need:in dataflow-file set c1 field to null and send message to email that c4 data field is not needed...

Please help!

YuriR · Accepted Answer · 2019-09-25 20:38:11Z

1

You can go this way:

GetFile -> Extract Text -> RouteOnAttribte -> UpdateAttribute

Where in extract text you can use regex, fetching you the first line with the header.

answered Sep 25, 2019 at 20:14

YuriR

1,3213 gold badges14 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1