topic Re: champs introuvable in QlikView

champs introuvable

master_student — Mon, 27 Feb 2017 07:51:55 GMT

Hello Guys,

I got this error "champs introuvable". bellow is my script :

test :

LOAD "MSISDN",

"OFFRE"

;

select SUBSTR(s.telephone_number, 4, 😎 as "MSISDN", p.offer_name as "OFFRE"

from p_edw.sub_offer o

left join p_edw.sub s on o.sub_id =s.sub_id

left join p_edw.off p on p.off_id = o.off_id

where (current_date between valid_from and valid_to );

exit script;

Any idea please?

Re: champs introuvable

Peter_Cammaert — Mon, 27 Feb 2017 08:01:30 GMT

You could temporarily omit the Preceding LOAD, execute the SQL code and inspect your table in Table Viewer (Ctrl-T). The fields returned from your DBMS may have different spelling, even if you rename them all to uppercase in the SELECT statement...

Re: champs introuvable

master_student — Mon, 27 Feb 2017 08:17:49 GMT

whene i execute the query without the load. it doesn't return any row. here the result :

here is the script :

select SUBSTR(s.telephone_number, 4, 😎 as "MSISDN", p.offer_name as "OFFRE"

from p_edw.sub_offer o

left join p_edw.sub s on o.sub_id =s.sub_id

left join p_edw.off p on p.off_id = o.off_id

where (current_date between valid_from and valid_to );

exit script;

and whene i add limit in my query. it runs :

select SUBSTR(s.telephone_number, 4, 😎 as "MSISDN", p.offer_name as "OFFRE"

from p_edw.sub_offer o

left join p_edw.sub s on o.sub_id =s.sub_id

left join p_edw.off p on p.off_id = o.off_id

where (current_date between valid_from and valid_to )

limit 1000;

it retunrs 1000 rows

whene i delelt the limit, it returns this error :

File extdata.cpp, Line 2903

Any idea pleaseee

Thanks