Load monthly files

[Markus_L]

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?

[Lisa_P]

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);