Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts,
Can any one please help me to create the below 3 oracle fields from query into Qlik.
Select
nvl(h.id, d.id) as id, // ...................... 1
nvl(h.productid, r.productid) as productid, // ................2
rank() over(
partition by nvl(h.id, d.id) , nvl(h.productid, r.productid)
order by h.validfrom desc, h.reportource desc
) as varrank // ......................... 3
from hours h
Thanks in advance
What happens when you do this?
LOAD *;
SQL
Select
nvl(h.id, d.id) as id,
nvl(h.productid, r.productid) as productid,
rank() over(
partition by nvl(h.id, d.id) , nvl(h.productid, r.productid)
order by h.validfrom desc, h.reportource desc
) as varrank
from hours h;
hi nagaraju,
I cant run the query its a big oracle query.
I have to extract each table from database and need to replicate the oracle logics into qlik.