topic Re: champs Introuvable in QlikView

champs Introuvable

master_student — Mon, 06 Nov 2017 08:30:30 GMT

Hello Guys,

I got the error bellow :

Champ introuvable - <period_id>

SELECT * FROM "GPPROD".p_edxxxll_index

left join "GPxxxxl_id

where assignment_type_id = 18

AND period_id >= 201601

and period_id <= '201710'

When i execute the query in green plume, it works perfectly :

Thank you

Re: champs Introuvable

Anil_Babu_Samineni — Mon, 06 Nov 2017 08:33:34 GMT

May be Add SQL Select ....

Re: champs Introuvable

master_student — Mon, 06 Nov 2017 08:42:57 GMT

the same error :

Champ introuvable - <period_id>

sql SELECT * FROM "GPPROD".xxxx

...

Re: champs Introuvable

prma7799 — Mon, 06 Nov 2017 09:00:51 GMT

Please check that period_id column is present or not in that table...

Re: champs Introuvable

master_student — Mon, 06 Nov 2017 09:35:38 GMT

yes. it is here is my script:

LOAD

period_id,

cell_id,

cell_site_id as site_id,

cell_name,

cell_manufacturer,

cell_technology,

total_revenu as Total_revenu,

data_revenu as Data_revenu,

voice_revenu as Voice_revenu,

weekend_revenu,

weekend_data_revenu,

weekend_voice_revenu,

voice_off_peack_revenu as Voice_off_peack_revenu,

voice_off_peack_data_revenu as Voice_off_peack_data_revenu,

voice_off_peack_voice_revenu as Voice_off_peack_voice_revenu,

data_off_peack_revenu as Data_off_peack_revenu,

data_off_peack_data_revenu as Data_off_peack_data_revenu,

data_off_peack_voice_revenu as Data_off_peack_voice_revenu,

voice_on_peack_revenu as Voice_on_peack_revenu,

voice_on_peack_data_revenu as Voice_on_peack_data_revenu,

voice_on_peack_voice_revenu as Voice_on_peack_voice_revenu,

data_on_peack_revenu as Data_on_peack_revenu,

data_on_peack_data_revenu as Data_on_peack_data_revenu,

data_on_peack_voice_revenu as Data_on_peack_voice_revenu

;

sql SELECT * FROM "Gxxxndex

left join "GPxxxndex.cell_id

where assignment_type_id = 18

AND period_id >= 201601

and period_id <= 201710;

exit script ;

Re: champs Introuvable

prma7799 — Mon, 06 Nov 2017 09:44:35 GMT

Try to give alias for table and try

sql SELECT * FROM "Gxxxndex a

left join "GPxxxndex.cell_id b

where assignment_type_id = 18

AND a.period_id >= 201601

and a.period_id <= 201710;

Re: champs Introuvable

stabben23 — Mon, 06 Nov 2017 09:52:52 GMT

Hi, could it be that you miss ON in Your left join?

sql SELECT * FROM "Gxxxndex a

left join "GPxxxndex.cell_id b ON

where assignment_type_id = 18

AND a.period_id >= 201601

and a.period_id <= 201710;

Re: champs Introuvable

Anil_Babu_Samineni — Mon, 06 Nov 2017 11:03:51 GMT

sql SELECT * FROM "Gxxxndex

    left join "GPxxxndex.cell_id

    where assignment_type_id = 18

    AND period_id >= 201601

    and period_id <= 201710;

    ...

Does Double quotes not closed anymore. May be the cause it throws error

Re: champs Introuvable

Peter_Cammaert — Mon, 06 Nov 2017 12:06:55 GMT

To test, omit the Preceding LOAD or put it in comments. Then run the SQL statement on its own, and see what you get in the table viewer (Ctrl-T). DBMS that comply with the ANSI SQL standard may return field names in all upper case.