topic Re: load in QlikView

load

Tue, 17 Jun 2014 11:47:23 GMT

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!

Re: load

Anonymous — Tue, 17 Jun 2014 11:49:24 GMT

How do you want to read the characters from Left or Right,

You can try like below

left(job_nummer,12) as Gesellschaft

or send me the conditions

Re: load

anbu1984 — Tue, 17 Jun 2014 11:50:38 GMT

In Oracle you can use SUBSTR

SQL SELECT "job_nummer",

jobnr,

"datum_auftrag",

Year ("datum_auftrag") as Jahr,

Month ("datum_auftrag") as Monat,

jobkategorie,

SUBSTR(job_nummer,11,2) As Gesellschaft

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

In qlikview

Mid(job_nummer,11,2)

Re: load

marcus_malinow — Tue, 17 Jun 2014 11:51:04 GMT

Hi Jan,

use the Mid function.

LOAD *,

mid(job_nummer, 11,2) as Gesellschaft;

SQL SELECT [the rest of your SQL]

Marcus

Re: load

ashfaq_haseeb — Tue, 17 Jun 2014 11:53:03 GMT

Hi try below

Load "job_nummer",

jobnr

"datum_auftrag"

Year ("datum_auftrag") as Jahr,

mid("job_nummer",11,2) as "Gesellschaft",

Month ("datum_auftrag") as Monat;

SQL SELECT "job_nummer",

jobnr,

"datum_auftrag",

jobkategorie

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

Regards

ASHFAQ

Re: load

Tue, 17 Jun 2014 11:55:10 GMT

It is a Pervasive database. I would like to read out only characters 11 and 12.

Re: load

Tue, 17 Jun 2014 11:59:02 GMT

Thanks Marcus. Works!