Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
capriconuser
Creator
Creator

Qvd to Excel

I am trying to save qvd file into excel in qlik sense 

but this shows an error 

Mapping:
LOAD
    "UAE.Name" as %Br_Map,
    "UAE .Point",
    "UAE .Area"
FROM [lib://Mapping/Data Store\Mapping\UAE.kml]
(kml, Table is [UAE/UAE_12]);


STORE Mapping into [C:\Users\HP\Box\B\QDevelopment\Data Store\Mapping.csv](txt);

exit Script;

 

error 

The following error occurred:
This statement only works with lib:// paths in this script mode
Labels (1)
2 Replies
mikaelsc
Specialist
Specialist

create a connection to the folder where you want to save the csv file and use it in your store statement. 

it must look just like your load statement: 

 

STORE Mapping into [lib://MyNewConnection\Mapping.csv](txt);

 

(or of course create 1 connection, and use subfolders in your load and store statements 🙂 

Anil_Babu_Samineni

This may Help too

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful