How To Avoid multiple if conditions

[#1]

How can I use 'Pick with match' functions for handling below multiple if conditions. I want to optimise below expression. Pls. help.

=if( DischargeDRG= '280' or DischargeDRG= '281' or DischargeDRG= '282' or DischargeDRG= '283' or DischargeDRG= '284' or DischargeDRG= '285','AMI'     

  ,if(DischargeDRG=  '216'or DischargeDRG='217'or DischargeDRG='218'or DischargeDRG='219'or DischargeDRG='220'or DischargeDRG='221'or DischargeDRG='231'or DischargeDRG='232'or DischargeDRG='233'or DischargeDRG='234'or DischargeDRG='235'or DischargeDRG='236', 'CABG or Valve'    

     ,if(DischargeDRG=  '246' or DischargeDRG= '247' or DischargeDRG= '248' or DischargeDRG= '249' or DischargeDRG= '250' or DischargeDRG= '251' or DischargeDRG= '286' or DischargeDRG= '287', 'Coronary Cath'    

       ,if(DischargeDRG= '222' or DischargeDRG= '223' or DischargeDRG= '224' or DischargeDRG= '225' or DischargeDRG= '226' or DischargeDRG= '227' or DischargeDRG= '242' or DischargeDRG= '243' or DischargeDRG= '244' or DischargeDRG= '245' or DischargeDRG= '258' or DischargeDRG= '259' or DischargeDRG= '260' or DischargeDRG= '261' or DischargeDRG= '262' or DischargeDRG= '265','EP'    

         ,if(DischargeDRG= '291' or DischargeDRG= '292' or DischargeDRG= '293','HF'   

            ,if(DischargeDRG= '288' or DischargeDRG= '289' or DischargeDRG= '290' or DischargeDRG= '294' or DischargeDRG= '295' or DischargeDRG= '296' or DischargeDRG= '297' or DischargeDRG= '298' or DischargeDRG= '299' or DischargeDRG= '300' or DischargeDRG= '301' or DischargeDRG= '302' or DischargeDRG= '303' or DischargeDRG= '304' or DischargeDRG= '305' or DischargeDRG= '306' or DischargeDRG= '307' or DischargeDRG= '308' or DischargeDRG= '309' or DischargeDRG= '310' or DischargeDRG= '311' or DischargeDRG= '312' or DischargeDRG= '313' or DischargeDRG= '314' or DischargeDRG= '315' or DischargeDRG= '316','Other Medical'    

                ,if(DischargeDRG= '228' or DischargeDRG= '229' or DischargeDRG= '230' or DischargeDRG= '237' or DischargeDRG= '238' or DischargeDRG= '239' or DischargeDRG= '240' or DischargeDRG= '241' or DischargeDRG= '252' or DischargeDRG= '253' or DischargeDRG= '254' or DischargeDRG= '255' or DischargeDRG= '256' or DischargeDRG= '257' or DischargeDRG= '263' or DischargeDRG= '264','Other Surgical'   

                  ,if(DischargeDRG= '1' or DischargeDRG= '2' or DischargeDRG= '001' or DischargeDRG= '002' or DischargeDRG= '215','VAD or Transplant',   

        'Non-Circulatory'

     ))))))))

[its_anandrjs]

Hi Pankaj,

Use Mapping table for this and Map this table with the Fact table or transaction table where this if logic requires. By doing this your application having good performance in load perspective also. For mapping create another mapping table and load the data as mapping table or you can use Inline tables. I explain this in Inline table

Ex:-

DiscMap:

Mapping Load * Inline [

DischargeDRG,Desc

280,AMI

281,AMI

282,AMI

283,AMI

284,AMI

285,AMI

220,Valve

221,Valve  ];

Fact:

Load

ApplyMap('DiscMap',DischargeDRG,'Non-Circulatory') as Details,

Fields,

....

From Source;

Regards

Anand