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


      Hi Everyone


      I have the following load statement:


      SQL SELECT "job_nummer",



          Year ("datum_auftrag") as Jahr,

          Month ("datum_auftrag") as Monat,


      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!