topic Re: Qvd to Excel in App Development

Qvd to Excel

capriconuser — Fri, 02 Apr 2021 08:14:06 GMT

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

Re: Qvd to Excel

mikaelsc — Wed, 01 Jan 2020 11:20:27 GMT

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 🙂

Re: Qvd to Excel

Anil_Babu_Samineni — Wed, 01 Jan 2020 12:17:45 GMT

This may Help too