3 Replies Latest reply: Aug 29, 2011 11:03 AM by Jörg Lortz RSS

    Loading Data/Script: Split daterange in single date items (lines)

      Hi everybody,

       

      another question:

       

      I have to load data via script:

       

      LOAD

           Id,

           Website,

           Event,

           Startdate,

           Enddate

      FROM

           ...

       

      You can see that there is a start- and enddate for every event in this table.

      Take a look at the table (example):

       

      IdWebsiteEventStartdateEnddate
      1000gulp.comProduct Roadshow2011/05/032011/05/06
      1001heise.deRelease 0.92011/08/302011/09/02

       

      I need to get ONE line for every single date. Is there a possibility to do this while running the import script (data reload script)?

       

      I need a imported table in a structure like this (added a new column "Date"):

       

      IdWebsiteEventStartdateEnddateDate
      1000gulp.comProduct Roadshow2011/05/032011/05/062011/05/03
      1000gulp.comProduct Roadshow2011/05/032011/05/062011/05/04
      ..................
      1000gulp.comProduct Roadshow2011/05/032011/05/062011/05/06
      1001heise.deRelease 0.92011/08/302011/09/022011/08/30
      ..................
      1001heise.deRelease 0.92011/08/302011/09/022011/09/02

       

      Thanks for every idea!

       

      jup