Not Able to create QVD

[Anonymous]

Hi,

I am not able to create QVD.

While using only Data load script it is loading from Data base but while writing Store Command to Store QVD, it is giving error that "Connection not found" I have created a folder connection.

Please let me know any specific access required for the same??

Thanks

Anirban

[danansell42]

Hi Anirban

Can you share the code you have for using the STORE command?

Maybe this is the issue...

It should be like the following:

Store Data into [lib://FOLDER/data.qvd](qvd);

Also, is the connection showing on the right hand side panel in Qliksense?

Dan

[Anonymous]

Hi Daniel,

Connections are showing in the right panel in Qlik sense.

Please find below code.

LIB CONNECT TO 'DB_Test (ecommerce_amitra)';

LOAD "Ariba Code",
    "Level 1",
    "Level 2";
SQL SELECT "Ariba Code",
    "Level 1",
    "Level 2"
FROM "Procurement_DW".dbo."Category_Mapping";
Store Category_Mapping into 'lib://QVD_Data/QV1.QVD' (qvd);

I have created connection as QVD_Data.

While Loading it is giving an error,

Connection Not Found: QVD_Data.

Thanks and Regards

Anirban

[danansell42]

The script looks ok...

If you go to the connection and click select data or edit connection does it bring up the correct folder?

[Anonymous]

Hi Daniel,

Yes it is showing up the correct folder.

Thanks

Anirban

[MK9885]

Try this?

Store Category_Mapping into [lib://QVD_Data/Category_Mapping.qvd] (qvd);

Note you should have a table name in place before Load statement. Which I don't see in your code

[Anonymous]

Hi Daniel,

Thank you for helping me.

Table name in place--> I not able understand the same.

Is anything else need to write over there, instead of what I mentioned.

Also I have tried above mentioned code, but still showing the same error.

Thanks

Anirban

[MK9885]

What folder destination you have?

Can you paste it here?

Ex: if you load a data from your Folder Connection, it will give you Lib.....

Can you provide that?

if possible give a screenshot of your script?

Connection not found is 'You did not set a connection and trying to save qvd in some other path.' if you have correct connection, it will store.

Or Create a new connection, extract some dummy data from that connection, it will provide with a script at the bottom.

From..... Lib

Copy only that lib part and use this code to store your connection and delete the dummy data script.

Thanks.