topic Re: Script result nothing in QlikView

Script result nothing

master_student — Tue, 21 Feb 2017 15:07:29 GMT

Hello Guys,

I really didn't get why my script doesn't work.

here is he script :

ODBC CONNECT32 TO vv_vv;

NoConcatenate

F_temp:

select

Tel,

p.off as "offer"

from p_edw.sub_off o

left join p_edw.subs s on o.subs_id =s.subs_id

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

where (current_date -1 between valid_from and valid_to );

exit script;

the result is nothing :

any help please

Thanks

Re: Script result nothing

sunny_talwar — Tue, 21 Feb 2017 15:09:50 GMT

May be check after adding SQL before SELECT

NoConcatenate

F_temp:

SQL select

SUBSTR(s.telephone_number, 4, 😎 as "Concern. MSISDN",

p.offer_name as "offer"

from p_edw.subcriber_offer o

left join p_edw.subs s on o.subs_id =s.subs_id

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

where (current_date -1 between valid_from and valid_to );

Re: Script result nothing

master_student — Tue, 21 Feb 2017 15:17:06 GMT

I added , SQL before my query but didn't get nothing

Re: Script result nothing

vishsaggi — Tue, 21 Feb 2017 15:21:12 GMT

May be here? there is no space for the table alias for p_edw.offp change it to p_edw.off p

NoConcatenate

F_temp:

SQL select

SUBSTR(s.telephone_number, 4, 😎 as "Concern. MSISDN",

p.offer_name as "offer"

from p_edw.subcriber_offer o

left join p_edw.subs s on o.subs_id =s.subs_id

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

where (current_date -1 between valid_from and valid_to );

Re: Script result nothing

sunny_talwar — Tue, 21 Feb 2017 15:21:53 GMT

Does this run outside QlikView?

select

SUBSTR(s.telephone_number, 4, 😎 as "Concern. MSISDN",

p.offer_name as "offer"

from p_edw.subcriber_offer o

left join p_edw.subs s on o.subs_id =s.subs_id

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

where (current_date -1 between valid_from and valid_to );

Re: Script result nothing

master_student — Tue, 21 Feb 2017 15:49:20 GMT

yes, it runs on geen plume

Re: Script result nothing

Tue, 21 Feb 2017 16:01:06 GMT

try this way,

no need 'as' in query.

And also check the date format in where condition.

select

SUBSTR(s.telephone_number, 4, 😎 "Concern. MSISDN",

p.offer_name "offer"

from p_edw.subcriber_offer o

left join p_edw.subs s on o.subs_id =s.subs_id

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

where (To_Char(current_date,'MM/DD/YYY') -1 between To_Char(valid_from,'MM/DD/YYYY') and To_char(valid_to,'MM/DD/YYYY' );

Re: Script result nothing

antoniotiman — Tue, 21 Feb 2017 16:03:25 GMT

May be

F_Temp:

NoConcatenate

......

Re: Script result nothing

Peter_Cammaert — Tue, 21 Feb 2017 16:26:51 GMT

"geen plume"? What Sunny means is does it run in the SQL query tool for your DBMS? First check overthere if your query is correct and returns any rows.

BTW Vishwarath has a good point - your SQL statement refers to a table alias p, but p is defined nowhere. Probably due to a missing space in

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

Re: Script result nothing

master_student — Tue, 21 Feb 2017 16:26:52 GMT

nop

Re: Script result nothing

master_student — Tue, 21 Feb 2017 16:31:09 GMT

green plume is a dbms and the p is fixed in my query

Re: Script result nothing

Peter_Cammaert — Tue, 21 Feb 2017 16:39:52 GMT

You mean Greenplum dbms? That dbms is PostgresSQL-based and therefor has a query tool called psql. You can test your queries by starting psql with the name of your database, and then running the same query by copy/pasting it at the command prompt.

Re: Script result nothing

master_student — Tue, 21 Feb 2017 16:45:28 GMT

thanks but it doesn't solve the pb