question Re: Apache nifi merge two different csv file and create combine output to json in Support Questions

question Re: Apache nifi merge two different csv file and create combine output to json in Support Questions https://community.cloudera.com/t5/Support-Questions/Apache-nifi-merge-two-different-csv-file-and-create-combine/m-p/235240#M197060 <A rel="user" href="https://community.cloudera.com/users/97382/chintan2010visani.html" nodeid="97382">@Chintan Visani</A>I believe it's possible. Let me explain my usecase first. My objective is to take 4 CSVs as input and joining all of them based on a unique column named 'CustomerID' available in all the CSVs. I did not directly join the CSVs rather I put each of them into database tables and later join them using ExecuteSQL command. 1. GetFile -> UpdateAttribute -> PutDatabaseRecord (For each of the CSVs i.e., for my case - 4 CSVs put into 4 different tables)<IMG alt="" />2. ExecuteSQL (you write SQL query to join all the required tables) -> ConvertRecord -> PutFile (This will give you the join of all the CSVs)3. After that again, GetFile -> UpdateAttribute -> PutDatabaseRecord (If you again want to put the aggregated/joined CSV into the DB, then you can do it again)<IMG alt="" />Hope it would help. Thanks and regards,Spandan. Mon, 14 Jan 2019 16:28:39 GMT spandan_mohanty 2019-01-14T16:28:39Z