This content has been marked as final. Show 6 replies
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!