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
- Routing File based on CSV header schema Austin Heyne
-