2 Replies Latest reply on Feb 25, 2016 10:05 AM by Rishiraj Abhange

    Excel Legacy Connection - "IF" / "CASE" statement

    Rishiraj Abhange

      Hello,

       

      I am aware that this has already been discussed in previous threads but I wanted to know if the "IF" / "CASE" statement in Excel Legacy connection is working using Custom SQL?

      It is popping up with "Microsoft JET database error 0x80004005:" for me.

      I am using Desktop v9.1.

       

      I am aware of the "iif" condition and it works perfectly fine. However, I wanted to use multiple "if" conditions in Custom SQL.

       

      Or else are there any workarounds for the same?

       

      Thanks!