Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

how to exit script before sythetic keys load

I am using just one App to load all my data from Oracle into my QVDs, then loading other apps from the QVDs. the issue it trys to create loads of synthetic keys and runs for hours, i dont need it to do this.

 

how can i stop the script running?

 

I have tried a simple End; or Exit Script; and neither seem to work

Labels (3)
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: how to exit script before sythetic keys load

I would recommend you to drop tables when you have no more use for them in your db extract application. 

 

Eg

Account:

SQL LOAD * FROM DB.dbo.ACCOUNTTABLE;

STORE Account into Account.qvd;

Drop table Account;

 

Location: 

SQL LOAD * FROM DB.dbo.LOCATIONTABLE;

STORE Location into Location.qvd;

Drop table Location;

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

1 Reply
Highlighted
Partner
Partner

Re: how to exit script before sythetic keys load

I would recommend you to drop tables when you have no more use for them in your db extract application. 

 

Eg

Account:

SQL LOAD * FROM DB.dbo.ACCOUNTTABLE;

STORE Account into Account.qvd;

Drop table Account;

 

Location: 

SQL LOAD * FROM DB.dbo.LOCATIONTABLE;

STORE Location into Location.qvd;

Drop table Location;

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post