9 Replies Latest reply: May 14, 2014 11:26 AM by Peter Magnusson RSS

    Load Multiple CSV file from the specified directory into a table

    Ramesh Kalathy

      Hi

       

      I need to load the csv file from the specific directory into a table.

      Can anyone tell me how to do it.

       

      For each csvFile in filelist ('$(vDirPath)*.csv')

      <TableName>:

      LOAD

       

      From $(csvfile)

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

      next csvfile

      I am getting on error that the from filename is missing.

       

      Thanks

      Ramesh