title: Bash script to find matching rows from multiple csv files and create report out of it
body: <p>I have three different CSV files. There format is as follows :</p>
  
  <pre><code>domain1.csv
  
  name1,lastname1
  name2,lastname2
  name3,lastname3
  
  domain2.csv
  
  name1,lastname1
  name6,lastname6
  name3,lastname3
  
  domain3.csv
  
  name1,lastname1
  name4,lastname4
  name3,lastname3
  </code></pre>
  
  <p>Now based on this three files i need to create report like this</p>
  
  <pre><code>name,lastname,domain1,domain2,domain3
  name1,lastname1,yes,yes,yes
  name2,lastname2,yes,no,no
  name3,lastname3,yes,yes,yes
  name4,lastname4,no,no,yes
  name6,lastname6,no,yes,no
  </code></pre>
  
  <p>Basically this report is only possible using a script which can read rows one by one in each file and find that row in other two files and create the report by matching the name and lastname columns. But i am a total newbie in shell scripting. Can someone help me. I am using bash.</p>