Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

NIFI - Joining 2 flowfiles with SQL JOIN operation

avatar
Explorer

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

avatar
Master Guru