topic sql error in qlik in QlikView

sql error in qlik

master_student — Wed, 08 Mar 2017 11:14:44 GMT

Hello

I didn't understand why i get this error : syntaxe error at or near select

here is the script :

The query runs on green plume and the connexion to the database works on qlikview

//connexion

SELECT "Concern. MDN", "offer"

FROM (SELECT SUBSTR(s.tt, 4, 😎 AS "Concern. MDN",

p.offer_name AS "offer",

Rank() over ( PARTITION BY s.tt ORDER BY o.valid_from DESC) AS last_offer

FROM p_edw.subber s

left join p_edw.subber_offer o ON o.subber_id = s.subber_id

AND To_char(o.valid_to, 'yyyy-mm-dd' :: text) = '9999-12-31' :: text

left join p_edffer p ON p.off_id = o.off_id) m

WHERE last_off = 1

exit script ;

PrashantSangle — Wed, 08 Mar 2017 11:16:45 GMT

What kind of error you are getting???

Please post your error msg??

try

SQL SELECT your query.

Regards,

Prashant

PrashantSangle — Wed, 08 Mar 2017 11:19:02 GMT

Hi,

In your from clause comment :: text and try/

FROM p_edw.subber s

left join p_edw.subber_offer o ON o.subber_id = s.subber_id

AND To_char(o.valid_to, 'yyyy-mm-dd' :: text) = '9999-12-31' :: text

left join p_edffer p ON p.off_id = o.off_id) m

Regards,

Prashant