2 Replies Latest reply: Sep 10, 2013 10:40 AM by Alan Cobbald RSS

    How to create multiple records based on each record loaded

      I have a table with multiple text fields and start & end date fields.

       

      I want to expand the table to create a record for each date between the start & end date.

       

      The source table has multiple rows.

       

      Simple example:

       

      Field      Start                End

      A1      01/01/2013      03/01/2013

      A2      06/01/2013      07/01/2013

       

      Result:

      Field      Start                Date

      A1      01/01/2013      01/01/2013

      A1      01/01/2013      02/01/2013

      A1      01/01/2013      03/01/2013

      A2      06/01/2013      06/01/2013

      A2      06/01/2013      07/01/2013

       

       

       

      Thanks