3 Replies Latest reply: May 19, 2016 8:03 AM by Annick Whitfield RSS

    Ignore an error when loading a file that does not exist

    Annick Whitfield

      Hello,

       

      I would like to ignore the error when loading a given file (File1) which does not exist but abort the same script if another given file (File2) does not exist.

       

      Here's my load script:

       

      Table1:

      LOAD

      Param1,

      Param2

      FROM [$(vConfigPath)File1.csv] txt, codepage is 1252, no labels, delimiter is ';', msq);

       

      Table2:

      LOAD

      Field1,

      Fiel2

      FROM [$(vConfigPath)File2.csv] txt, codepage is 1252, no labels, delimiter is ';', msq);

       

      If File1 does not exist I would like the script to continue.

      If File2 does not exist I would like the script to abort.

       

      Many thanks in advance.