convert statement

[soniasweety]

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'

[Vegar]

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'

[soniasweety]

cant we load this query directly into qlikview?   

same this query?  if yes how 

[Vegar · Accepted solution]

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

[Brett_Bleess]

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