loading different excel files -automation

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

//NEXT

Data:

LOAD

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

;

Re: loading different excel files -automation

adamdavi3s — Mon, 21 Nov 2016 08:03:31 GMT

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