Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Creating and storing a QVD file

Hi

I am trying to create and store a QVD and getting an error. Can someone please help debug?

sec_master:
LOAD security_id,
name,
bb_identifier,
bb_unique_id,
country
FROM

(
qvd);

OUTER join LOAD
security_id,
classification
FROM

(
qvd);
STORE core_sec INTO (qvd);

Getting following error message:

Labels (3)
1 Solution

Accepted Solutions
magavi_framsteg
Partner - Creator III
Partner - Creator III

Hi Dave.

There is no table called core_sec.

You should try “STORE sec_master” instead.

Med vänliga hälsningar / Best Regards

Magnus ÅVITSLAND

Business Intelligence Architect

*Edit: Removed personal details.

View solution in original post

5 Replies
MK_QSL
MVP
MVP

STORE sec_master INTO (qvd);

magavi_framsteg
Partner - Creator III
Partner - Creator III

Hi Dave.

There is no table called core_sec.

You should try “STORE sec_master” instead.

Med vänliga hälsningar / Best Regards

Magnus ÅVITSLAND

Business Intelligence Architect

*Edit: Removed personal details.

Not applicable
Author

Thanks Magnus, I tried STORE sec_master without specifying path but it didn't work.

Also tried STORE sec_master INTO [C:\Users\APPE741\Desktop\MSCI_Classification

i.e. removing sec_master.qvd from the syntax above but it doesn't work. I've seen usage of 'lib' somewhere but not sure if having C:\\ instead of Lib is the problem here.

Any other suggestion?

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Please, the qlikbug group is intended for discussing potential bugs

(software defects). Please post general problems in the Qliview or

QlikSense development areas.

Thanks,

Rob

Not applicable
Author

Hi Rob,

'll do.

Thanks