nifi-users mailing list archives

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

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?

Thanks,

James

On Thu, Mar 16, 2017 at 11:14 AM, Austin Heyne <aheyne@ccri.com> 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
>
>

Mime
View raw message