loading different excel files -automation

Anonymous · ‎2016-11-20

Hi All,

i have two excel files like Annuites_2016_Plan Master.Xlsx, R_IS_2016_Plan Master, every year we will place the folder in path

so can we automate this ?

can you please help me on this

i tried like below

let vYear=Year(Today());

let vQVD = '..\QVD\Extract\';

for each vFile in FileList('..\ExternalData\*$(vYear) _ Plan Master.xlsx')

//for Each vSheet in '[Plan Master]','[Jan-Jun]'

let vQVD = replace(vFile, '.xlsx', '.qvd');

if alt(FileSize('$(vQVD)'), 0) = 0 then

NextFile:

LOAD

*

FROM $(vFile)

(ooxml, embedded labels, table is $(vSheet))

;

STORE NextFile INTO $(vQVD) (qvd);

DROP TABLE NextFile;

end if

Data:

LOAD

*

FROM ..\QVD\Extract\*.qvd (qvd)

;

adamdavi3s · ‎2016-11-21

You don't really tell us where your issue is here, which bit of it is failing?

I did a recent blog post on some more advanced imports, this one imports text files but goes through and checks if they're new and logs them etc