Re: Joining multiple tables with left join relation

2022-12-08 Thread Matt Burgess
Michał, There are some options in NiFi that should work for you, we have LookupRecord [1] which does simple enrichment based on a common field (such as id) that acts like a SQL left join, there are a series of articles [2] to explain in more detail. For more complex use cases there are

Joining multiple tables with left join relation

2022-12-08 Thread KURTYKA, M. (MICHA�) via users
Hi, I'm trying to join one "master" table with multiple enrichment tables by common id with relation that would resemble SQL left join. Is something like that possible in NiFi? Which processors will be most efficient for that? Only column they share is id. Kind regards Michał Kurtyka ING