topic Re: convert statement in QlikView

convert statement

soniasweety — Sat, 16 Nov 2024 00:55:09 GMT

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'

Re: convert statement

Vegar — Thu, 02 Apr 2020 13:27:18 GMT

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'

Re: convert statement

soniasweety — Thu, 02 Apr 2020 13:56:16 GMT

cant we load this query directly into qlikview?

same this query? if yes how

Re: convert statement

Vegar — Thu, 02 Apr 2020 14:10:27 GMT

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';

Re: convert statement

Brett_Bleess — Wed, 29 Apr 2020 11:59:07 GMT

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