Skip to main content
Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikapple
Creator
Creator

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

 

Labels (1)
2 Replies
Gysbert_Wassenaar

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
qlikapple
Creator
Creator
Author

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