2 Replies Latest reply: Dec 18, 2012 12:52 AM by Jörg Hildebrandt RSS

    combine a key-table with a calendar

    Jörg Hildebrandt

      Hello all

       

      I want to load from an existing table several fields as a key

       

      Temp:
      LOAD * INLINE [
      field1, field2, field3

      A, B, C

      D, E, F
      ]

      ;


      Table:
      load field1&'/'&field2&'/'&field3 as key
      resident Temp;
      Drop Table Temp;

       

      The result

      A/B/C

      D/E/F

      I want to join with a calendar (01.01.2012 to 31.12.2012), so having at the end 730 data sets:

       

      A/B/C01.01.2012
      A/B/C02.01.2012
      A/B/C03.01.2012
      A/B/C04.01.2012
      A/B/C05.01.2012
      A/B/C06.01.2012
      A/B/C07.01.2012etc
      D/E/F01.01.2012
      D/E/F02.01.2012
      D/E/F03.01.2012
      D/E/F04.01.2012
      D/E/F05.01.2012
      D/E/F06.01.2012
      D/E/F07.01.2012etc

       

      Can someone have an idea how to solve this ?

       

      Thanks a lot.

       

      Joerg