2 Replies Latest reply: Jan 7, 2014 11:52 AM by Mavrinder Dhothar RSS

    Resident Load issue

      Hey guys,

       

      Im having trouble doing a resident load. The following error message appears when I reload:

       

      Table not found:

      TableDQ
      etc etc

       

      The resident load I tried is below:


      [Filepath...\1198028.xlsx]

      (
      ooxml, embedded labels, table is [Tab1]);

      Table_DQ:    

      LOAD

      [FITR],

      if(FITR_No_Data='Fail', 'Fail',

      if(FITR_ZeroValue='Fail', 'Fail',
      if(FITR_DashValue='Fail', 'Fail',
      if(FITR_DotValue='Fail', 'Fail',
      if(FITR_MaxChar='Fail', 'Fail')))))  as FITR_DQ,

      if(Report_Status_No_Data='Fail', 'Fail',
      if(Report_Status_ZeroValue='Fail', 'Fail',
      if(Report_Status_DashValue='Fail', 'Fail',
      if(Report_Status_DotValue='Fail', 'Fail',
      if(Report_Status_CN='Fail', 'Fail'))))) as Report_Status_DQ,

       

       

       

      Resident Directory;

       

       

      Anybody know what is going wrong?

       

      Thanks

       

      Mav