Searching other codes in script

Tue, 04 Sep 2012 09:38:28 GMT

Hi,

I have the following script showing in my load script.

LOGINFO:

LOAD *, [logdate] as Logdate_Month,

Year([logdate]) as Logdate_Year

,num(today()) - 1460 as test123

,num([logdate]) as logdatetest

, if(MID(fixcode,11,4)='RCL0','Oracle'

, if(MID(fixcode,11,4)='RRCL','Oracle'

, if(MID(fixcode,11,4)='0000','Bottomline'

, if(MID(fixcode,11,4)='FRMS','Bottomline'

, if(MID(fixcode,11,4)='C000','Call Media'

, if(MID(fixcode,11,4)='CLLM','Call Media'

, if(MID(fixcode,11,4)='CSCD','Cascade'

, if(MID(fixcode,11,4)='CSC9','Cascade'

, if(MID(fixcode,11,4)='CST6','Castelle'

, if(MID(fixcode,11,4)='CM02','Client Manager'

, if(MID(fixcode,11,4)='CGNS','Cognos'

, if(MID(fixcode,11,4)='CYBR','Cyborg'

, if(MID(fixcode,11,4)='RCYB','Cyborg'

, if(MID(fixcode,11,4)='DSCV','Discoverer'

, if(MID(fixcode,11,4)='HXGN','Hexagon'

, if(MID(fixcode,11,4)='HSBC','HSBC Net'

, if(MID(fixcode,11,4)='FS00','IFS'

, if(MID(fixcode,11,4)='FS20','IFS'

, if(MID(fixcode,11,4)='MO04','Maximo'

, if(MID(fixcode,11,4)='MA03','Maximo'

, if(MID(fixcode,11,4)='MDS1','Midas'

, if(MID(fixcode,11,4)='MDS0','Midas'

, if(MID(fixcode,11,4)='QLK1','Qlikview'

, if(MID(fixcode,11,4)='QLKW','Qlikview'

, if(MID(fixcode,11,4)='RC50','Reports'

, if(MID(fixcode,11,4)='SVRN','Severn Trent'

, if(MID(fixcode,11,4)='STRT','Streetworks'

, if(MID(fixcode,11,4)='STRM','Strumap'

, if(MID(fixcode,11,4)='S006','Syclo'

, if(MID(fixcode,11,4)='S008','Syclo'

, if(MID(fixcode,11,4)='VRSN','Version One'

, if(MID(fixcode,11,4)='VRS1','Version One'

, if(MID(fixcode,11,4)='MPCT','WaterXP'

, if(MID(fixcode,11,4)='ERXP','WaterXP'

)))))))))))))))))))))))))))))))))) AS SOFTWARE_TEST

where num(today()) - 1460 < [logdate];

As you can see I have quite alot of if statements that look at a specific code and then enter it as a specific software value.

However there may be some code that are no in the above list, however I want to show them as other. Can this be done.

Re: Searching other codes in script

Tue, 04 Sep 2012 10:00:38 GMT

Hi Jonathan,

behind last 'WaterXP' word add following: ,'Other value' .

regards

Re: Searching other codes in script

whiteline — Tue, 04 Sep 2012 10:09:45 GMT

Hi.

It's cool

Try applymap() instead.

topic Re: Searching other codes in script in QlikView

Searching other codes in script

Re: Searching other codes in script

Re: Searching other codes in script