RE:Nested If to Case

[Chanty4u]

Hi all,

I  hve small issue on  if and case condition.

How can i chnge this  Nested If  condition to  Case . 

If(TYPE='A', 'A',

If(TYPE='B/C',

  If(SOURCE='D',

'D','B'), TYPE)) AS PLATFORM,

Thanks in advance 

[Gysbert_Wassenaar · Accepted solution]

You can't afaik. The switch-case flow control structure doesn't work in load statements.

[Chanty4u]

yeah...but

we are trying to implement the above code in case expression in select statement.

how can i do this ?