I have 2 flow files (tables in CSV format) and I need to merge them into one flow file, but to do that I need to perform a SQL JOIN operation because I only need data that exists in one table but not in the other.
Is there a way to do this in NIFI?
During the workflow I also convert the format to JSON and perform a SPLIT operation on the data, maybe it’s easier to get the result in need after these conversions.
Example for what I need:
The result should be: