Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
master_student
Creator III
Creator III

champs introuvable

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?

2 Replies
Peter_Cammaert
Partner - Champion III
Partner - Champion III

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...

master_student
Creator III
Creator III
Author

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

Capture.PNG

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