4 Replies Latest reply: Jan 25, 2018 1:45 PM by Sunny Talwar RSS

    Field Not Found - Data Load - * versus no * - Debugging

    Michael Porco

      Hello,

       

      First load works (exact filename).  No errors.  Second doesn't and it creates an error (Field not found, Field X not found) when I use the '*' character.

       

      Essentially everything is the same except I use the '*' in the Second and it's unclear to me what's causing the error.  I'm having difficulty debugging this scenario. Any insight on best practices when it comes to debugging would be much appreciated.  I noticed several items posted on this topic but none of the items helped (or I didn't find it).

       

      First:

      Load

           Field 1

           Field 2

      FROM [FILE Location\Filename1234.csv]

      (txt, codepage is 1252, embedded labels, delimiter is ',', msq)

      Where Field_X...

       

      Second:

      Load

           Field 1

           Field 2

      FROM [FILE Location\Filename*.csv]

      (txt, codepage is 1252, embedded labels, delimiter is ',', msq)

      Where Field_X...

       

      Thanks,

       

      Michael