Qlik Community

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

sahajaqlik
Contributor

need help in sql query to convert in load script

Hi all , i have a query of

 

OPOWNER LIKE '%NCCDESK%' AND NOT OPOWNER LIKE '%NCCDESK3' AND NOTOPOWNER = 'NCCDESK99' AND NOT OWNER = 'CiscoMSO' ) AND SEV > 1

can anyone please convert in qlik script, i need to  keep in where condition in my qvd

 

2 Replies
MVP & Luminary
MVP & Luminary

Re: need help in sql query to convert in load script

Something like this:

WHERE

WildMatch(OPOWNER ,'*NCCDESK*')

AND NOT WildMatch(OPOWNER ,'*NCCDESK3')

AND NOT OPOWNER = 'NCCDESK99'

AND NOT OWNER = 'CiscoMSO' 

AND SEV > 1


talk is cheap, supply exceeds demand
Highlighted
sahajaqlik
Contributor

Re: need help in sql query to convert in load script

HI , I NEED THIS SQL QUERY ALSO TO GET WRIITEN IN QLIK SCRIPT ( MOMREGION = 'HSE' AND DOMAINCLASS = 'ZSER' AND ( TTYPE LIKE 'EQ%' OR TTYPE IN ('070I', 'U071I') ) OR MOMREGION = 'HTSE' AND DOMAINCLASS = 'ZSER' AND TTYPE IN ('F450I', 'IE51I', 'IEF4I', 'IEF4' ) AND SETCLASS = 'BATCH' ) OR ( MOMREGION = 'HSN' AND DOMAINCLASS = 'ZSER' AND TTYPE LIKE 'EQ%' OR MOMREGION <> 'HSL' AND DOMAINCLASS = 'ZSER' AND sETCLASS = 'CA7' ) OR ( MOMREGION IN ('HSA', 'HSE', 'HSN') AND SERVICES IN ('HUBHIL', 'HUBE', GROUP-TWO', 'HBME-MULTI-COUNTRY-HUB-GROUP-THREE', 'HUBHDE', 'HUBHIT', 'HUBLOH', 'HUBHPL') AND (SUBSET LIKE '%BCH' OR SUBSET LIKE '%OWNER' OR SUBSET LIKE '%BCHTTS' ) AND DOMAINCLASS = 'ISIES' AND NOT OBJECT IN ('SSKEPALV1','SSKEPALV2') OR MOMREGION IN ('HSA', 'HSE', 'HTSN') AND ( UBSET LIKE 'HUB%' AND tYPE = 'Automation Point' OR TEMPLATE = 'USA' ) AND DOMAINCLASS = 'ISES' OR MOMREGION IN ('HTSA', 'HTSE', 'HTSN') AND SUBSETCLASS LIKE '%BATCH%' AND ORIGINTYPE = 'Automation Point' AND DOMAINCLASS = 'ISES' OR MOMREGION IN ('HTSA', 'HTSE', 'HTSN') AND DOMAINCLASS = 'ISERIES' AND DOMAIN IN ('wink003', 'wink006', 'brum000', 'brum001') ANDOBJECTCLASS = 'ROBOT' ) OR ( ( MOMREGION = 'HTSE' AND NOT REGION = 'CH' AND DOMAINCLASS = 'CONTROL' ) OR (MOMREGION = 'HTSE' AND NOT REGION = 'CH' AND DOMAINCLASS like 'CTLM%' ) ) OR ( (MOMREGION IN ('HSA', 'HSN') AND DOMAINCLASS = 'CONTROL' ) OR (MOMREGION IN ('HTSA', 'HTSN') AND DOMAINCLASS LIKE 'CTLM%' ) ) OR ( MOMREGION IN ('HTSA', 'HTSE', 'HTSN') AND SERVICES IN ('MMO REMIND', 'AMH HCC', 'HASE HCC', 'HBBM HCC', 'AUH ATMP', 'NZM ATMP', 'AMHK IMS', 'ASP-ME-HIE', 'AMH HIE', 'TWM CACS') AND (SUBSET LIKE '%BCH' OR SUBSET LIKE '%OWNER' OR SUBSET LIKE '%BCHTTS' ) AND DOMAINCLASS = 'ISEIES' OR MOMREGION IN ('HTSA', 'HTSE', 'HTSN') AND SUBSETCLASS = 'HKBCH' AND ORIGINTYPE = 'Automation Point' AND DOMAINCLASS = 'ISERIES' )