topic Re: How to load the multilple excels through for each loop? in QlikView

How to load the multilple excels through for each loop?

Wed, 08 Apr 2015 04:00:40 GMT

Hi ,

I have requriement,i get the 4 excels daily,how to load that excels automatically?

Regards,

QvDeveloper

Re: How to load the multilple excels through for each loop?

Wed, 08 Apr 2015 09:01:06 GMT

You can use a for next script in load

This is an example:

I'd need to load data for the last seven weeks

FOR i = 0 to 7
currWeek = Week(Now())- i
currWeekFile = If (Len($(currWeek))=2, $(currWeek), '0'&$(currWeek))

SET currFileName = <file_path>\<common_file_name>$(currWeekFile).QVD;

IF not IsNull(QvdTableName('<file_path>\<common_file_name>' & $(currWeekFile) & '.QVD')) then
DataTable:
LOAD *

From $(currFileName) (qvd)
ENDIF

NEXT

Regards

Re: How to load the multilple excels through for each loop?

Anonymous — Wed, 08 Apr 2015 09:11:48 GMT

Load list of files in a Folder