"where" statement

[#1]

Hi Everyone

I have the following script:

LOAD *,

mid(job_nummer, 11,2) as Gesellschaft;

I would like to include only values that are "AG", "AP" and "DC"

How would I have to script this?

Thank you very much for your help!

[ashfaq_haseeb]

Hi try below

LOAD *,

mid(job_nummer, 11,2) as Gesellschaft;

FROM EASY.job where "datum_auftrag" is not null

and mid(job_nummer, 11,2) in ("AG", "AP" and "DC);

Regards

ASHFAQ

[#3]

hm, that one does not work for me...

[ashfaq_haseeb]

Hi try this

LOAD *,

mid(job_nummer, 11,2) as Gesellschaft;

FROM EASY.job where "datum_auftrag" is not null

and mid(job_nummer, 11,2) in ('AG', 'AP' and 'DC');

Regards

ASHFAQ

[#5]

Thank you for your help Ashfaq. Still get an error with this code...

[tresesco]

LOAD *,

mid(job_nummer, 11,2) as Gesellschaft

resident <> Where Match(job_number, 'AG', 'AP' ,'DC');

[gandalfgray]

The Load you are trying to do, is that from a sql source or from a resident table?

[tresesco]

And, if you are loading from DB then try like Ashfaq as suggested with a small correction: remove And  and try like :

in ('AG', 'AP' , 'DC');

[gandalfgray]

And if loading from resident I think it should be:

where match(mid(job_nummer, 11,2),'AG', 'AP', 'DC');

[#10]

Hi GandalfiGray

I am loading data from a pervasive database.

Thank you for your help...