Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
jacqueshol
Creator
Creator

Loading multiple files in Qlik Sense

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:

  • Ops Report - 2017 07.xlsx
  • Ops Report - 2017 08.xlsx
  • Ops Report - 2017 09.xlsx
  • Ops Report - 2017 10.xlsx

...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

1 Solution

Accepted Solutions
pedrobergo
Employee
Employee

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

View solution in original post

3 Replies
pedrobergo
Employee
Employee

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

jacqueshol
Creator
Creator
Author

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

farolito20
Contributor III
Contributor III

I am trying to use this methodology but it only allow me to load 5 files.