title: Combine files records with repeated ID in BizTalk
body: <p>I have another case where I don't know how to find a solution with BizTalk.</p>
  
  <p>I have this two flat files (in real there are 9 files to combine) and the output must be like shown in the picture:
  <a href="https://i.stack.imgur.com/5JiUA.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5JiUA.jpg" alt="enter image description here"></a></p>
  
  <p>How can I combine files which ID repeat several times in the main file. </p>
  
  <p>In the below picture, the main file is "People". Is there way to do this without writing any code in BizTalk, or must I store this data in SQL DB after that i join them with a stored procedure? </p>
  
  <p>Can you help me lay-out the steps I need to take, because I know how to combine files together but that is without the repeated ID's. </p>