Discussion board where members can get started with Qlik Sense.
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')
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
2) Does not recognise C:
For each vFileName in Filelist ('lib://C:\Dropbox\Trading\Data\*.csv')
(txt, utf8, embedded labels, delimiter is ',', msq);
Can you try the below script:
Set vConcatenate = ;
'' AS SourceFile
for each FileExtension in 'Qvd'
for each FoundFile in filelist( Root & '\*.' & FileExtension)
[Sales Amt TW],
[Sales Amt LW],
FileBaseName() as FileName
Set vConcatenate = Concatenate;
for each SubDirectory in dirlist( Root & '\*' )
Call ScanFolder('C:\Users\Qlik\Documents\QVD\') ;
change the file extension from qvd to csv and path of the data.
else share the sample excel file.
Did not load anything as the CSV is red in the script at $(FoundFile)(CSV)
Have you checked the example 2 in the help section?
you have to adjust the script.
(ooxml, embedded labels, header is 1 lines, table is Yearly)
for Qvd no need of (ooxml, embedded labels, header is 1 lines, table is Yearly).
for CSV you have to add the following.
else share at least one CSV file.
may be this. The chnaged part is in red
For each File in FileList('$(vPath)'&'*.csv')
From '$(File)' (txt, utf8, embedded labels, delimiter is ',', msq);
Still does not read the file.
Do you mean like this? If so it did not work.
$(FoundFile)(CSV)(ooxml, embedded labels, header is 1 lines, table is Yearly);
I have example files to the initial post.
Using that I still get an error in connection not found to C, ie. call DoDir ('lib://C:\Dropbox\Trading\Data')