title: Talend -- one row to many, variable number of output rows
body: <p><strong>Background:</strong> It's common in Talend to use something like tSplitRow to map one row with many fields into multiple rows. A row with fields:</p>
  
  <p><code>Date | Name | MorningPhone | Day Phone | EveningPhone</code>
  ...could be split into:</p>
  
  <p><code>Date | Name | Phone</code> ... and you'll always have 3 resulting rows from one row.</p>
  
  <hr />
  
  <p><strong>Question:</strong> What if I want number of rows from a variable number of fields?</p>
  
  <p>I have a schema: <code>UniqueID | FieldSet</code> where FieldSet is a delimited field of columns divisible by nine. If there are 45 fields, in this delimited column, I want 5 rows. 81 fields => 9 rows. </p>
  
  <p>I'm trying to use tJavaRow to parse the fields, but I don't know how to combine that with tSplitRow to generate the appropriate number of fields.</p>
  
  <p>Ideas? Thanks!</p>