Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a simple file in the format listed below (Fig. A). When I load the data in either an xlxs or csv file type the output is as listed in Fig. B. What am I doing wrong?
Fig, A
State | Abbreviation | Name 1 | Name 2 |
---|---|---|---|
Alabama | AL | Steve | Henry |
Arizona | AZ | Steve | Jim |
Fig. B
That looks like a file header of a not recognized format. Can you attach the file you are trying to load?
The source file is not what it seems like - it is not an Excel-file nor a CSV-file.
The header indicates that it is DRM - protected and encrypted - so it has to be decrypted first before it is
usable. Then you can use it in Qlik Sense.
DRM = Digital Rights Managment
Probably copied in the wrong or unauthorized way from a SharePoint site with DRM-enabled.
From Samsungs website:
Document Security Solution (NASCA) NASCA is a DRM solution guaranteeing safe distribution of electronic documents with encryption and authority management features to take preemptive measures in preventing losses due to illegal leakages of all electronic documents created within the company.
Google says that your xlsx or csv file is encrypted by some DRM security software. You'll have to ask whoever gave you that file to give you an unencrypted copy.