nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Wing <>
Subject Re: Routing File based on CSV header schema
Date Thu, 16 Mar 2017 18:27:11 GMT

I think you are on the right track with RouteOnContent.  Any chance you can
share a sample CSV header, the settings of your RouteOnContent processor,
including the regex?



On Thu, Mar 16, 2017 at 11:14 AM, Austin Heyne <> wrote:

> Hi,
> I have a set of CSV files with headers that utilize various schemas. I'd
> like to route the CSV files to processors based on the schema set in the
> header. I've tried using the RouteOnContent processor to sort the files
> based on "content must contain match" and a regex statement that matches
> the first line (header). However, this is throwing an 'unmatched' on every
> file I send through.
> I've also looked at the ValidateCsv processor but it doesn't appear that
> works with the header but rather just validates data types. Unfortunately
> this won't work as columns with the same data type could be in a different
> order.
> Is there a ready made solution for this problem that I missed or perhaps a
> more clever way to approach it?
> Thanks,
> Austin Heyne

View raw message