Load monthly files

Markus_L — Thu, 21 Apr 2022 10:27:42 GMT

Hello to all,

We have monthly Excel files in a drive.

The current period is already recognizable in the file name (P02_final, P03_final, etc.)

I would like to create a bar graph where I can display the individual monthly values (period) per ID number (available in all files).

E.g. period 1 -> value 100

Period 2 -> Value 95

Period 3 -> value 105

How do I have to program this in the loading script so that I can display the monthly value?

Re: Load monthly files

Lisa_P — Fri, 22 Apr 2022 04:43:25 GMT

Use the FileName() function to add that to the data in the load script like this:

LOAD
"Date",
Sales,
Subfield(FileName(), '.', 1) as File
FROM [lib://Monthly/*.xlsx]
(ooxml, embedded labels, table is Sheet1);