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

Reply via email to