Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
I have been searching all over the community, but haven't been able to find an answer on what I would've thought should be a fairly simple question.
I have monthly Excel sheets that have operational information. They are all exactly the same in layout, headers and content. The are saved as follows:
...and so on.
The number of files obviously grow every month and I therefore need a script that would allow for it. I want to bring these files into Qlik Sense, but just can't seem to get the script right. I have done this before in QlikView and that was a doddle through the use of wildcards, but this doesn't seem to work in Qlik Sense. An example of how I did it in QlikView can be found below:
LOAD
Date,
[Vehicle Registration],
[Weight Loaded],
[Fuel Cost],
[Distance]
FROM
[Ops*.xlsx]
(ooxml, embedded labels, table is Data);
This worked really well, but I now need a similar script in Qlik Sense. Any help would be greatly appreciated.
Take care,
Jacques
Hi Jacques,
I think all these files are in the same directory. So you need to set a folder Connection 'OpsFolder'.
Then you just use these connection as QV.
LOAD
Date,
[Vehicle Registration],
[Weight Loaded],
[Fuel Cost],
[Distance]
FROM [lib://OpsFolder/Ops*.xlsx]
(ooxml, embedded labels, table is Data);
[]
Pedro
Hi Jacques,
I think all these files are in the same directory. So you need to set a folder Connection 'OpsFolder'.
Then you just use these connection as QV.
LOAD
Date,
[Vehicle Registration],
[Weight Loaded],
[Fuel Cost],
[Distance]
FROM [lib://OpsFolder/Ops*.xlsx]
(ooxml, embedded labels, table is Data);
[]
Pedro
Hi Pedro,
I did exactly that and couldn't get it to work. However, I deleted the app and started it over again and now it worked just fine. I must've missed a step somewhere.
Anyway, thank you kindly for your assistance. Data pulling in nicely now.
Take care,
Jacques
I am trying to use this methodology but it only allow me to load 5 files.