question Re: How to Extract only header of a csv file in NiFi ? in Support Questions

How to Extract only header of a csv file in NiFi ?

Paul012 — Fri, 30 Jul 2021 06:59:55 GMT

which processor can be used to extract(read) only the header( 1st row of the file) of a csv file.

Re: How to Extract only header of a csv file in NiFi ?

Daming Xue — Fri, 30 Jul 2021 06:36:10 GMT

Hello

You can refer here:

https://stackoverflow.com/questions/55070778/extract-only-the-columns-header-from-the-csv-file-using-nifi

Re: How to Extract only header of a csv file in NiFi ?

Paul012 — Fri, 30 Jul 2021 06:43:13 GMT

why do we need ReplaceText processor here, could you please explain? .I just want to extract the header (1st row) . and do not want to replace the header with any other text.

Re: How to Extract only header of a csv file in NiFi ?

adhishankarit — Fri, 30 Jul 2021 20:12:02 GMT

Hi,

Once you extracted the header into Flowfile attribute using ExtractText processor, next you are going to convert the header flowfile attribute into Flow file content OR you can keep the header value as in attribute ..The stack overflow explains about extracting header into flowfile attribute and next they have pass the headers as file into destination .To convert flowfile attribute to file/flowfile content ,we will have to use ReplaceText processor where you can pass flowfile attributes .. The success relationship of ReplaceText will only contains header in flowfile content and the original csv file will be replaced with header as content . The flowfile content, you can transfer to destination or next processor in the flow.

Hope this information you are looking for ..

Thanks