Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Issue with using Qvc.ImportModel #96

Open
AndrewGri opened this issue Jan 12, 2023 · 3 comments
Open

Issue with using Qvc.ImportModel #96

AndrewGri opened this issue Jan 12, 2023 · 3 comments

Comments

@AndrewGri
Copy link

Qlik Sense.

An application loads data using Qvc.ImportModel call. Previously model was exported by another ("Transform") application. At the first time data loaded successfully. But starting from the second attempt to execute load script the following error appears:
"... The control statement is not correctly matched with its corresponding start statement...".

I found that error disappears after adding the following code after Qvc.ImportModel call:

Set _qvctemp.TableName = ;
Set _qvctemp.FieldNames = ;

@RobWunderlich
Copy link
Owner

Can you post your script please, including the CALL statements?

@AndrewGri
Copy link
Author

Sure.

Here it is:


Table:
LOAD
	*
INLINE [
	ProductCode, Cost
    PR1, 100
];

CALL Qvc.ExportModel('lib://QS Models/model');

DROP TABLE Table;

CALL Qvc.ImportModel('lib://QS Models/model/QVC Check.qvd');

CALL Qvc.Cleanup;

For the first time everything is Ok, but starting from the second attempt the error message appears:

image

@balexbyrd
Copy link

I can also confirm that I have the exact same issue and when I set the variables prior to including the Qvc.qvs file the issue was resolved.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants