Support Questions
Find answers, ask questions, and share your expertise

NIFI - Joining 2 flowfiles with SQL JOIN operation

NIFI - Joining 2 flowfiles with SQL JOIN operation

New Contributor

Hello everyone,

 

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:

Csv1:

1,a,NY

2,b,SF

3,w,SP

 

Csv2:

1,a,NY

3,w,SP

 

The result should be:

2,b,SF

 

Thank you!

1 REPLY 1

Re: NIFI - Joining 2 flowfiles with SQL JOIN operation

Super Guru