12 Replies Latest reply: Aug 29, 2013 4:26 AM by Srividhya Sampath RSS

    Need to find fields which contains NULL values

      hi all,

      in this below script my DESG and PH.NO fields contains null values. but i cant get that fields name by using the below IF condition. Please help me on this .

       

      test:
      LOAD [Emp No],
           [Emp Name],
           Desg,
           Address,
           Ph.No,
           If(IsNull([Emp No]),'[Emp No]' , If(IsNull([Emp Name]),'[Emp Name]' , If(isnull(Address),'Address' , If(isnull(Ph.No),'Ph.No' , If(isnull(Desg),'Desg'))))) as NullFields
      FROM
      [alert testing data.xlsx]
      (ooxml, embedded labels, table is Sheet1);

       

      thnx