topic Re: query not working in script in QlikView

query not working in script

qlikapple — Wed, 25 Nov 2020 16:16:04 GMT

hi all,

i have a query which is working fine in oracle ,

if i am keeping the same query in qlikview load script, it is throwing error,

can anyoe please help.

please find the below query which is working fine in oracle

SQL

select
* from
(
SELECT * FROM lplada.MEASURED_PLO WHERE PERIOD_ID IN (
SELECT PERIOD_ID FROM MEASUREMENT_PERIOD WHERE FRQ_ID=4 AND (TO_CHAR(START_DATETIME,'MON-YYYY') like TO_CHAR(CURRENT_DATE,'MON-YYYY')
or TO_CHAR(START_DATETIME,'MON-YYYY') like TO_CHAR((current_date-extract(day from current_date)),'MON-YYYY') )
)
and PLO_ID IN (SELECT DISTINCT PLO_ID FROM lplada.PLO WHERE PLA_ID IN (1122,6973,7343,7363,7703,8083,9723,18223,19684,19728,19843,22195,26017,21541,26847,28497,28739,32680,33286,33600,39524,41255,39560)
AND KPI_CODE IN (12,20) and frq_id = 4 and STATUS_CODE='ACTIVE')

) A

inner JOIN

(SELECT * FROM MEASUREMENT_PERIOD WHERE (TO_CHAR(START_DATETIME,'MON-YYYY') like TO_CHAR(CURRENT_DATE,'MON-YYYY')
or TO_CHAR(START_DATETIME,'MON-YYYY') like TO_CHAR((current_date-extract(day from current_date)),'MON-YYYY') )
) B

on A.PERIOD_ID = B.PERIOD_ID;

can anyone please tell me for which the query needs to get run fine in qlikview load script as well.

the error which i am geting is below.

Re: query not working in script

jobsonkjoseph — Wed, 31 Oct 2018 09:04:55 GMT

Hi Sahaja,

Have you tried the debug option in script editor.

Re: query not working in script

qlikapple — Wed, 31 Oct 2018 09:08:12 GMT

yes i have tried

Re: query not working in script

qlikapple — Wed, 31 Oct 2018 09:14:08 GMT

Its very urgent can anyone please help

Re: query not working in script

Aurelien_Martinez — Wed, 31 Oct 2018 09:18:37 GMT

Hi,

Your sql request "select * from" return two fields named MODIFIED_MEASURE_PLO

Aurélien

Re: query not working in script

qlikapple — Wed, 31 Oct 2018 12:39:25 GMT

anyone please help

Re: query not working in script

tharanikannan — Thu, 01 Nov 2018 05:31:32 GMT

Hi ,

This issue comes , when you try to rename a field with an existing name on the same table. Kindly check your script again.

Re: query not working in script

jobsonkjoseph — Thu, 01 Nov 2018 05:42:14 GMT

Dear Sahaja,

Is this the first data pull, i mean is there any other data in the application, if so is the data model without any duplicates.

Just a thought.

Re: query not working in script

Mark_Little — Thu, 01 Nov 2018 08:47:47 GMT

It suggests that the field MEASURED_PLO exists already.

Is that the full load script?

Have you just tried loading that table.

Also you would normally expect to see

Load * before the SQL select

Mark