Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

load multiple excel files

 

I have multiple excel files that are the exact same, columns and headings all the same and same order.

 

All files only have one sheet but the sheet name is different.

 

Below is my script I am trying to get to work, it works with a text file but not excel.

 

What am I doing wrong?

 

 

 

LOAD

 

    OrderDate,

 

    OrderNumber,

 

    FacilityName,

 

    FacilityID,

 

    RouteNumber,

 

    ScheduledLeaveTime,

 

    ActualLeaveTime

 

FROM [lib://HealthEX (pharmore_rwinkel)/*.xlsx]

 

(ooxml, embedded labels, table is

  • );
  •  

    1 Solution

    Accepted Solutions
    lironbaram
    Honored Contributor II

    Re: load multiple excel files

    assuming the table is on the first sheet in the file

    this will work for you

    FROM [lib://HealthEX (pharmore_rwinkel)/*.xlsx]

    (ooxml, embedded labels);

    1 Reply
    lironbaram
    Honored Contributor II

    Re: load multiple excel files

    assuming the table is on the first sheet in the file

    this will work for you

    FROM [lib://HealthEX (pharmore_rwinkel)/*.xlsx]

    (ooxml, embedded labels);