topic Re: I want to load data from excel in QlikView

I want to load data from excel

Paknanarn23 — Mon, 26 Jan 2026 18:19:17 GMT

I want to load data from excel where the file name will be 20230127_220124 where 220124 is the time of the night shift. I want to get the name of the file to catch again when loading. What should I do?

Re: I want to load data from excel

Vegar — Sat, 28 Jan 2023 06:49:05 GMT

You can fetch the file name of the file you are loading by using the FileName() function.

Load *, FileName() as FileName

From .../20230127_220124.xlsx (...);

Re: I want to load data from excel

Paknanarn23 — Mon, 30 Jan 2023 02:41:34 GMT

Hi Vegar

So how do I get the files split into shifts like this?

Re: I want to load data from excel

Vegar — Mon, 30 Jan 2023 17:51:46 GMT

Try this

Load *,

Dayname(date#(Subfield(FileBaseName(), '_',1), 'YYYYMMDD' )) as file_date,

time(time#(Subfield(FileBaseName(), '_',2),'hhmmss')) as file_time,

FileName() as file_name

From .../20230127_220124.xlsx (...);