21 Replies Latest reply: Oct 11, 2017 7:30 AM by Cameron Vine RSS

    Load multiple CSV files into a table

    Cameron Vine

      I have attempted to adapt code from other Qlik community threads but still to no avail. All i want is to put together all the csv files in a folder into one table.

       

      Neither of these scripts work

      1) Provides no error message

       

      vPath = 'C:\Dropbox\Trading\Data\'

       

      For each File in FileList('$(vPath)*.csv')

      TableName:

      Load

      Date(Date#([@1], 'DD/MM/YYYY') ) AS [Date],

      [@2] AS [Open],

      [@3] AS [High],

      [@4] AS [Low],

      [@5] AS [Close],

      [@6] As [Volume],

      [@7] As [Open Interest],

          LEFT(FileBaseName (), 6) as Code_CSV

       

      From $(File);

      NEXT

       

      2) Does not recognise C:

       

      For each vFileName in Filelist ('lib://C:\Dropbox\Trading\Data\*.csv')

            Load *,

      Date(Date#([@1], 'DD/MM/YYYY') ) AS [Date],

      [@2] AS [Open],

      [@3] AS [High],

      [@4] AS [Low],

      [@5] AS [Close],

      [@6] As [Volume],

      [@7] As [Open Interest],

          LEFT(FileBaseName (), 6) as Code_CSV

            From [$(vFileName)]

            (txt, utf8, embedded labels, delimiter is ',', msq);

      Next vFileName