Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
The problem iam facing with the script is .. it always takes the source files only from where the qvw is placed. Even changing the path to the different drive it does take the file from their..
All my files are placed in a folders like 2014.csv /2015.csv etc.. so the csv file names are like file1-2014. so here file1-2014 needs to be into product. similarly I have file2-2014...etc
sub GetCSVFIleNames(Root)
for each FoundFile in filelist( Root & '\*.csv')
FoundFile = right('$(FoundFile)', 8);
Product:
LOAD
Customer Number,
Customer Name,
Product name] as [Product Name],
[Product number] as [Product Number]
FROM
['$(FoundFile)'\file1-'$(FoundFile)']
(txt, codepage is 1252, embedded labels, delimiter is ',', msq, header is 1 lines);
next FoundFile
for each SubDirectory in dirlist( Root & '\*' )
call GetCSVFIleNames(SubDirectory)
next SubDirectory
end sub
Call GetCSVFIleNames('H:/') ;
I don't find this correct answer option to close it..or is it helpful ?
If you have logged on to the portal you must see the options to select a correct answer option with a green *
may be this post can help you
https://community.qlik.com/message/867616#867616
thanks
Sasi
hi sasi.
Iam facing a small problem here. when iam processing the same file in 2 load statements. it is only considering the first load statement..
second it is not loading