HOWTO Load a double entry table

Anonymous · ‎2016-08-11

Hi!

I need to load multiple files from a folder (all files have the same structure).

Each files shows the sales on each month of the year. Inside the file the sales are shown as the below table.

Example: July.xls

Day	Branch1	Branch2	Branch3
07-01-2016	100	200	300
07-02-2016	250	350	450
07-03-2016	120	220	320
....

Can anybody guide me on how to load this information, since I have to load at least 5 years of sales.

Thank you.

Best regards

swuehl · ‎2016-08-11

You can use a FOR EACH vFile in FILELIST('*.xls') ... NEXT

to iterate over all your files in the folder.

Then LOAD your data, maybe transform the tables using