5 Replies Latest reply: Nov 23, 2016 10:16 AM by David Bockol RSS

    In Function

    David Bockol

      The syntax underlying the "In" function is incorrect.  I need help correcting the "In" Function.  The attached files provide the supporting documents.  Here's the script containing the "In function:

       

      LOAD *, if([Policy Type]='U','STB',if([Policy Type] in ('B','S'),'FRM',if(isnull([Profession Descr]),'NEW',[Profession Flag]))) as Profession