Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
These techniques will help.
Looks like the same thread here