topic Reuse same script to get data from multiple sources in QlikView https://community.qlik.com/t5/QlikView/Reuse-same-script-to-get-data-from-multiple-sources/m-p/402540#M697852 <HTML><HEAD></HEAD><BODY><P>I am developing an App that is extracting data from a financial system. There are 3 different databases for 3 business entities. I want to reuse the same script for each data source as they have an identical schema.</P><P></P><P>I am thinking of writing the common LOAD/SELECT statements in an include file and load it three times.&nbsp; Something like the following:</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13600324829967014" jivemacro_uid="_13600324829967014"><P></P><P></P><P>ODBC CONNECT32 To [&lt;connection string 1&gt;];</P><P></P><P></P><P>$(Include=script.txt);</P><P></P><P></P><P></P><P></P><P>ODBC CONNECT32 To [&lt;connection string 2&gt;];</P><P></P><P></P><P>$(Include=script.txt);</P><P></P><P></P><P></P><P></P><P>ODBC CONNECT32 To [&lt;connection string 3&gt;];</P><P></P><P></P><P>$(Include=script.txt);</P><P></P></PRE><P></P><P></P><P>Is this a sensible approach?&nbsp; Is there any best practice for handling this situation?</P></BODY></HTML> Tue, 05 Feb 2013 02:49:00 GMT 2013-02-05T02:49:00Z Reuse same script to get data from multiple sources https://community.qlik.com/t5/QlikView/Reuse-same-script-to-get-data-from-multiple-sources/m-p/402540#M697852 <HTML><HEAD></HEAD><BODY><P>I am developing an App that is extracting data from a financial system. There are 3 different databases for 3 business entities. I want to reuse the same script for each data source as they have an identical schema.</P><P></P><P>I am thinking of writing the common LOAD/SELECT statements in an include file and load it three times.&nbsp; Something like the following:</P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13600324829967014" jivemacro_uid="_13600324829967014"><P></P><P></P><P>ODBC CONNECT32 To [&lt;connection string 1&gt;];</P><P></P><P></P><P>$(Include=script.txt);</P><P></P><P></P><P></P><P></P><P>ODBC CONNECT32 To [&lt;connection string 2&gt;];</P><P></P><P></P><P>$(Include=script.txt);</P><P></P><P></P><P></P><P></P><P>ODBC CONNECT32 To [&lt;connection string 3&gt;];</P><P></P><P></P><P>$(Include=script.txt);</P><P></P></PRE><P></P><P></P><P>Is this a sensible approach?&nbsp; Is there any best practice for handling this situation?</P></BODY></HTML> Tue, 05 Feb 2013 02:49:00 GMT https://community.qlik.com/t5/QlikView/Reuse-same-script-to-get-data-from-multiple-sources/m-p/402540#M697852 2013-02-05T02:49:00Z