1 Reply Latest reply: Nov 22, 2017 1:06 PM by Chad Gambone RSS

    Importing multiple files into a single table

    Chad Gambone

      I have a directory with 15 or so CSV files that all have the exact same field names and structure.  When I use the code:

       

      CLReviewData:

       

      LOAD * FROM directory\*.csv (txt, codepage is 1253, embedded labels, delimiter is ',', msq);

       

      It works for most of the tables, but it doesn't work for 2 of the files.  Instead, it will import them into CLReviewData-1 and CLReviewData-2. 

       

      Any thoughts on what can be causing that?