topic Re: How do I make the equivalent of QV's Preceding Load in SQL? in QlikView

How do I make the equivalent of QV's Preceding Load in SQL?

julioarriaga — Wed, 23 Aug 2017 15:58:42 GMT

I will make some SQL experts cringe with this question, sorry ; I am self-taught and a rookie in QV and SQL.

So, I want to thank everybody in advance for the help.

I learned recently the use of QV's preceding loads. I need to do something similar to a QV's preceding load in a SQL query but I can't get my head around it.

This is the query I'm trying to do (code and image). Basically I'm trying to do the total count of records of a select grouped of records, but it marks me the following error in the Teradata SQL Assistant (image 2):

select count(*)

from (select Producto_ID, count(Producto_ID)

from DWH.MF_PRODUCTO_ORGANIZACION

where 1=1

and EntidadLegal_ID='191'

and Tipo_Producto_ID='1'

group by Producto_ID

having count(Producto_ID)>1

);

(image 1)

(image 2)

Re: How do I make the equivalent of QV's Preceding Load in SQL?

devarasu07 — Wed, 23 Aug 2017 16:22:46 GMT

Hi,

Try to keep only inner select query and remove outer select count(*) part (refer below screen highlighted one in yellow)

Re: How do I make the equivalent of QV's Preceding Load in SQL?

sunny_talwar — Wed, 23 Aug 2017 16:23:14 GMT

check this out

GML blog: Nested SQL Query syntax for Teradata (Teradata syntax error 3707)

Re: How do I make the equivalent of QV's Preceding Load in SQL?

sunny_talwar — Wed, 23 Aug 2017 16:24:09 GMT

May be this

select count(*)

from (select Producto_ID, count(Producto_ID) Count

from DWH.MF_PRODUCTO_ORGANIZACION

where 1=1

and EntidadLegal_ID='191'

and Tipo_Producto_ID='1'

group by Producto_ID

having count(Producto_ID)>1

) p;

Re: How do I make the equivalent of QV's Preceding Load in SQL?

Peter_Cammaert — Wed, 23 Aug 2017 16:37:45 GMT

This is a nested SELECT.

If you omit the outer select count(*) from (...), does the inner SELECT work ok on your Teradata DB? Does it produce the expected output?

Re: How do I make the equivalent of QV's Preceding Load in SQL?

julioarriaga — Wed, 23 Aug 2017 16:43:12 GMT

Hi, yes, it does :s

Re: How do I make the equivalent of QV's Preceding Load in SQL?

sunny_talwar — Wed, 23 Aug 2017 16:44:14 GMT

Did you try to look at the link I provided?

Re: How do I make the equivalent of QV's Preceding Load in SQL?

Peter_Cammaert — Wed, 23 Aug 2017 16:58:00 GMT

Sunny may be right. Your SQL engine appears to be complaining about the last ); lacking a name.

Try to name the result set of the inner select (Sunny called it p)