2 Replies Latest reply: May 22, 2014 5:09 PM by Amir Shadab 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>

       

      Thanks.