Hi, I need to compare several csv columns with values from my db. To do so I use the LookupRecord with concat various csv columns and the corresponding concat of sql columns in the DatabaseRecordLookupService. This works fine as long as I do not have any NULL values in my db. If there is a NULL value the Lookup Processor always routes those datasets to unmatched, as an empty string in the csv does not match the NULL values from the db. What needs to be written in the corresponding csv column so that it matches the db NULL value? I already tried to insert 'null', 'NULL' and 0 in the csv but it never matched the db value. Thanks for your help! ... View more

Hi, is there a way to find and remove duplicate entries in two flowfiles? I have one flowfile generated with SQL Processor with entries from my database. The other one contains new and "old" entries. So in order to only write the new entries in the database, I have to detect and remove the entries that already exist in the other flowfile. I already tried the HashContentProcessor but it hashes the content of the whole file. I would need a processor that hashes line for line (and then compares all hashes with each other). Thanks for your help! ... View more