1. I need to copy files from remote FTP server to my Local server . The FTP server has different files so i need to copy on my local server based on combination of fileName and currentDate . 2. Also i need to store the metadata of these input files (like fileName, createdDate, fileType, fileSize) . This metadata has to be inserted in Database table (for each input file which will be copy from FTP to local server) . 3. Now i need to schedule this entire process on 1st of every month. ... View more

I have two csv files : Sample files as below : file1.csv: Name,PAN,Organization,TIN raj,Awppp1234R,Erica,EWUIP1876T avinav,EOKLP8970Y,Optus,efgtu8976t brijesh,Qoplo1987U,InfoGaint,rhfuo1348r raj,Awppp1234R,Erica,EWUIP1876T file2.csv : Name,PAN,Organization,TIN raj,Awppp1234R,Erica,EWUIP1876T sanjay,RTRGH1679E,INFY,WJKOI1894G himanshu,POLKJ1673T,data69,TVBHU186B I want to find out unique records b/w these 2 sample files on the basis of PAN and TIN using apache nifi . so the output should be like this : raj,Awppp1234R,Erica,EWUIP1876T avinav,EOKLP8970Y,Optus,efgtu8976t brijesh,Qoplo1987U,InfoGaint,rhfuo1348r sanjay,RTRGH1679E,INFY,WJKOI1894G himanshu,POLKJ1673T,data69,TVBHU186B I am new to nifi , I don't know which processors I can use to solve this problem . Please let me know the complete flow to solve this problem . ... View more