Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey All,
I am new to Qlikview and trying to load a SQL CTE statement. I read a blog post and looks like you can do it, but I am having problems using it with Load.
This works with no error but putting a LOAD *; statement in front does not.
SQL with CTE
as
(
SELECT
*
FROM
Certification.dbo.Employee
)
select
* from
CTE
Hi,
I tired this and working for me.
Please use the below script.
Script:
load *;
sql with CTE
as
(
select * from Certification.dbo.Employee
)
select * from CTE;
Its working for we.
Please find the below.