I also had the same issue here and I’m new to Apache NiFi. Just curious does this way of concatenation a well accepted method for multi-column lookup in NiFi community? I’m asking because because it does not sounds efficient from database perspective where you use more storage space. And then you need to index this concatenated column for lookup speed. Another consideration is that should we use stored procedure in database (MySQL for example) to do this kind of multi-column lookup? In this way there is no additional column created. But in this way I don’t know how to send these results from stored procedure back to my NiFi flow for subsequent processing. Thanks and looking forward to your reply!
... View more
