Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all @Vegar @sunny_talwar Brett_Bleess
i want to convert this sql query to qlikview how can i convert this?
select CONCAT(Region,ID) from PERS.vw_list A
where ID not in
(select distinct big_ID from PERS.dim_bm_exception)
and ID='AOP'
If you are loading from the database you can.
Connect to your database
SQL select CONCAT(Region,ID) from PERS.vw_list A
where ID not in
(select distinct big_ID from PERS.dim_bm_exception)
and ID='AOP';
Something like this:
LOAD big_ID from PERS.dim_bm_exception;
LOAD
Region & ID as RegionID
FROM
PERS.vw_list
WHERE
NOT EXISTS(big_ID ,ID) and
ID='AOP'
cant we load this query directly into qlikview?
same this query? if yes how
If you are loading from the database you can.
Connect to your database
SQL select CONCAT(Region,ID) from PERS.vw_list A
where ID not in
(select distinct big_ID from PERS.dim_bm_exception)
and ID='AOP';
Sonia, I am going to mark Vegar's last post as the solution, but he is correct, you can run any SQL functions provided the DB Connector you are using in the Connect statement in our load script is capable of processing those functions. Sometimes the Connectors are somewhat restricted in what they can process, so you may find that some things will not work when you try to run them from our script in which case the best thing would be to check the Vendor support site for the Connector you are using to see if the have documented what will/will not work through the Connector. Hopefully this makes some sense.
Here is an Article that may be of some help too:
https://support.qlik.com/articles/000040748
Regards,
Brett