title: combine multiple columns in pig?
body: <p>I am entirely new to Pig. I want to combine multiple columns from two relation A and B using iid field. This seems to be simple, but I cannot figure out how to do it correctly, i've tried join but since there is no column in common it givs nothing.</p>
  
  <p>so here is my data:</p>
  
  <pre><code>A
  FullName Age CIN
  
  B    
  evaluation productivty
  </code></pre>
  
  <p>and I want my output to be like this:</p>
  
  <pre><code>FullName Age CIN Evaluation Productivty
  </code></pre>
  
  <p>..       ..  ..     ..         ..</p>
  
  <p>Thanks</p>