topic Multiple File reading in QlikView

Multiple File reading

Fri, 17 Dec 2010 12:55:07 GMT

I have a scenario , would like to know the best practice.

I have a folder which is input folder for QV . There everyday new excel files are dropped from other application. QV should refresh its dashboards with new input excel files everyday. The input files to QV having names appended with date but data format is same.

How the data loading should be so that loading is proper with minimal change in QV application?

Please suggest.

Multiple File reading

Fri, 17 Dec 2010 13:55:45 GMT

Try this

This is for csv-file

so change the .csv to .xls

and (ansi, txt, delimiter is ';', embedded labels, msq)

SUB doDir(dir)

FOR EACH file in filelist('$(dir)\*.csv')
LET vBasename = subfield( subfield('$(file)', '\', -1), '.', 1);
filelist:
LOAD '$(vBasename)' as basename,
'$(file)' as file
AUTOGENERATE 1
;
NEXT
END SUB

CALL doDir('C:\Dir')

// Each file represents a table.
if fieldvaluecount('basename')>0 then
FOR i = 1 to fieldvaluecount('basename')
TableSE:
LET vBasename = fieldvalue('basename', i);
LET file = fieldvalue('file', i);

LOAD
Dealer,
SALES_PERSON_NR,
OPTION_TYPE
from [$(file)] (ansi, txt, delimiter is ';', embedded labels, msq);

drop table filelist;

Multiple File reading

Mon, 20 Dec 2010 07:32:52 GMT

Thanks for the reply . Need few more suggestion. If in a folder everyday QV expects new files with in same format with daily records. Now after one year we might require to have Qtrly as well as yearly.

Hence what should be correct startegy for file handling. My plan is each day read daily record and conctenate of data in qvd file after reading archive the file nto different folder. When we run qtrly or yearly trend load the data from .qvd files. Please suggest if there is any better approach.

Multiple File reading

suniljain — Thu, 06 Jan 2011 14:43:34 GMT

you are in right way for solution of this issue. you can make qvd and quarterly and yearly data you can easily extract from qvd.