3 Replies Latest reply: Feb 5, 2016 10:04 AM by Sangram Reddy RSS

    Conversion of IF

    Ravikiran Pat

      Hi All,

       

      Can anyone help me with the conversion of below if loop to case statement. I want to use the below logic in the select statement.

       

      if(MATCH_TYPE = 'VOD','Tier 1',

        if(MATCH_TYPE <> 'VOD' AND Match(NETWORK_TYPE,'Broadcast', 'Cable') AND Len(Trim(PROGRAM_NAME)) <> 0,

            if((TIMESHIFT_INDICATOR_ID >= 10 AND TIMESHIFT_INDICATOR_ID <= 16) And SAMPLE <> 0,

                  'Tier 2','Tier 1')))

      As Field_Name