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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can ONE ETL(script) code be used by different qvw files?

Hi,

I have 5 qvw files. I want these files share the same load script. So I can renew one script, it is better than edit each qvw files. How can I do this?

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

Yes, it is possible. you could achieve this with the help of include statement.

Create your load script in text file and save that text file on your folder, Assume the text file which you have created is "ETL_TEST_LOAD.TXT" and you could call this in all your Qlikview application using Include statement.When ever you do changes to the txt file, it would automatically reflect in all your applications.

Your code should be as follow

$(Include=c:\users\desktop\qlikview\qlikview test\ETL_TEST_LOAD.TX)

-Sridhar

View solution in original post

2 Replies
Not applicable
Author

Hi,

Yes, it is possible. you could achieve this with the help of include statement.

Create your load script in text file and save that text file on your folder, Assume the text file which you have created is "ETL_TEST_LOAD.TXT" and you could call this in all your Qlikview application using Include statement.When ever you do changes to the txt file, it would automatically reflect in all your applications.

Your code should be as follow

$(Include=c:\users\desktop\qlikview\qlikview test\ETL_TEST_LOAD.TX)

-Sridhar

Not applicable
Author

hi

simply put your whole load script into a .txt file and Include this file by your all qlikview files by include command in the Edit tab of the Edit Script Dialouge box.

regards

A'run'Idea