How can I compare the one line in one CSV with all lines in another CSV file?
<p>I have two CSV files:</p>

<ol>
<li><code>Identity(no,name,Age)</code> which has 10 rows</li>
<li><code>Location(Address,no,City)</code> which has 100 rows</li>
</ol>

<p>I need to extract rows and check the <code>no</code> column in the <code>Identity</code> with <code>Location</code> CSV files.</p>

<p>Get the single row from <code>Identity</code> CSV file and check <code>Identity.no</code> with <code>Location.no</code> having 100 rows in <code>Location</code> CSV file.</p>

<p>If it is matching then combine the <code>name, Age, Address, City</code> in <code>Identity, Location</code></p>

<p>Note: I need to get 1st row from <code>Identity</code> compare it with 100 rows in <code>Location</code> CSV file and then get the 2nd row compare it with 100 rows. It will be continue up to 10 rows in <code>Identity</code> CSV file.</p>

<p>And overall results convert into Json.Then move the results in to SQL Server.</p>

<p><strong>Is it possible in Apache Nifi?</strong></p>

<p>Any help appreciated.</p>