I've been playing with the LookupRecord processor. So far so good.
I have use-cases, where I want to enrich multiple columns at the same
time (e.g. enrich with customer information for a certain customer_id),
or where there are multiple keys that should match. I think this would
be a useful improvement, for this processor.
On the other hand, a more flexible approach would be, if the QueryRecord
processor would allow joins against e.g. the SimpleCSVFileLookupService.
A query could look like this:
SELECT customer_id, customer_name, customer_address
FROM flowfile
LEFT JOIN MySimpleCsvFileLookupService ON flowfile.customer_id =
MySimpleCsvLookupService.customer_id;
This would be extremely flexible. What do you think?
Mika>