Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

ZIP ERROR?

It worked ok the first time but when I pasted two files with data in them I get a Zip Error?

LOAD

    FACILITY,

    "EMPLOYEE ID",

    HIREDATE,

    TERM_DATE,

    PAYTYPE,

    "WORKED DATE",

    "HOURS",

    "JOB TITLE CODE"

  

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

(ooxml, embedded labels, table is Contractor_Data_Entry);

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Any XLSX file is a ZIP-file. Maybe your XLSX-file was corrupt and that is why you get the error message.

You could try to make a copy of both of your Excel files and change the extensions from XLSX to ZIP. Then try unzipping both of them and see if Windows report any ZIP-error....

View solution in original post

2 Replies
Highlighted
MVP
MVP

Any XLSX file is a ZIP-file. Maybe your XLSX-file was corrupt and that is why you get the error message.

You could try to make a copy of both of your Excel files and change the extensions from XLSX to ZIP. Then try unzipping both of them and see if Windows report any ZIP-error....

View solution in original post

Highlighted
Not applicable

I did not know that all XLSX are zip files.

Thank you for your help

Bob