5 Replies Latest reply: May 28, 2014 2:38 AM by sanjeet phoughat RSS

    "ScriptErrorDetails" not fetching multiple error details

      Hi,

       

      I need help in using ScriptErrorDetails.

      I am using below code to fetch data from multiple excel files:

        ---------------------------------
      Read_Files:

      LOAD
      *

      FROM
      Z:\files\*my_file*.xlsx
      (
      ooxml, embedded labels, table is Open);

      ErrorDetails:
      Load
      '$(ScriptErrorDetails)'
      as vScriptErrorDetail
      AutoGenerate(1);

      ------------------------------------

       

      After running this, i get following value in vScriptErrorDetail :

      Field not found - <Emp-Id>

       

      However there were 2 fields that were missing in different files:

      Emp-Name column was missing in one and Emp-Id column in another.

       

      But vScriptErrorDetail is storing only error in file read last.

       

      I want vScriptErrorDetail  to give following result:

      Field not found - <Emp-Name>

      Field not found - <Emp-Id>

       

      If we have 2 or more field error during the reload, my purpose is to show my users that these are the fields causing the error. Hope I am making it clear for you to help.