How to load the multilple excels through for each loop?

[#1]

Hi ,

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

Regards,

QvDeveloper

[#2]

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

[Anonymous]

Load list of files in a Folder