2 Replies Latest reply: Sep 4, 2012 6:09 AM by whiteline _ RSS

    Searching other codes in script

      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.