6 Replies Latest reply: Jun 17, 2014 7:59 AM by Jan Heinrichsdorff RSS

    load

      Hi Everyone

       

      I have the following load statement:

       

      SQL SELECT "job_nummer",

          jobnr,

          "datum_auftrag",

          Year ("datum_auftrag") as Jahr,

          Month ("datum_auftrag") as Monat,

          jobkategorie

      FROM EASY.job where "datum_auftrag" is not null;

       

      I would like to generate a new field called "Gesellschaft" that contains characerts 11-12 from all entries in "job_nummer".

       

      Could somebody give me advise how to script this?

       

      Thank you very much for your help!