This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I got this error "champs introuvable". bellow is my 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 );
Any idea please?
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...
whene i execute the query without the load. it doesn't return any row. here the result :
here is the script :
and whene i add limit in my query. it runs :
where (current_date between valid_from and valid_to )
it retunrs 1000 rows
whene i delelt the limit, it returns this error :
File extdata.cpp, Line 2903
Any idea pleaseee