title: How to create multiple output files in Talend based on a column from an SQL Input
body: <p>I have a need of creating multiple output files based on a value (column) from an sql input in Talend Open Studio.</p>
  
  <p>My tMSSQLInput returns about 50,000 rows in which where one of the columns is the building_name</p>
  
  <p>Building A
  Building B
  Building C
  ....</p>
  
  <p>So all rows that have value "Building A" should be in an excel file named "buildingA.xls", all rows that have "Building B" should be in an excel file named "buildingB.xls" and so on.</p>
  
  <p>I have been trying to use tLoop or tForEach along with tIterateToFlow but I am not sure that I know how to implement it.</p>
  
  <p>Thanks in advance.</p>