topic Generate Load Scripts with TSQL (Meditech DR) in QlikView https://community.qlik.com/t5/QlikView/Generate-Load-Scripts-with-TSQL-Meditech-DR/m-p/1316115#M618379 <HTML><HEAD></HEAD><BODY><P>Thought I would give back to the community that has been an immense resource for me.&nbsp; About a year ago I created the attached TSQL scripts that generate Qlik <STRONG>LOAD</STRONG> commands for any number of tables in a Microsoft SQLServer database.&nbsp; The places to alter are the <STRONG>WHERE</STRONG> clauses to further filter the result set(s).&nbsp; Also, change the <STRONG>STORE/FROM</STRONG> lines to reflect your relative path location.&nbsp; If there are any questions, or opportunities to improve, please let me know.&nbsp; Thank you!</P><P></P><P>This was prompted by a posting&nbsp; <A href="https://community.qlik.com/docs/DOC-16495">"Show Me the Data"</A>‌ by Dalton Ruer - <A href="https://community.qlik.com/qlik-users/196928">drr</A>‌</P></BODY></HTML> Tue, 25 Apr 2017 14:08:22 GMT Tanalex 2017-04-25T14:08:22Z Generate Load Scripts with TSQL (Meditech DR) https://community.qlik.com/t5/QlikView/Generate-Load-Scripts-with-TSQL-Meditech-DR/m-p/1316115#M618379 <HTML><HEAD></HEAD><BODY><P>Thought I would give back to the community that has been an immense resource for me.&nbsp; About a year ago I created the attached TSQL scripts that generate Qlik <STRONG>LOAD</STRONG> commands for any number of tables in a Microsoft SQLServer database.&nbsp; The places to alter are the <STRONG>WHERE</STRONG> clauses to further filter the result set(s).&nbsp; Also, change the <STRONG>STORE/FROM</STRONG> lines to reflect your relative path location.&nbsp; If there are any questions, or opportunities to improve, please let me know.&nbsp; Thank you!</P><P></P><P>This was prompted by a posting&nbsp; <A href="https://community.qlik.com/docs/DOC-16495">"Show Me the Data"</A>‌ by Dalton Ruer - <A href="https://community.qlik.com/qlik-users/196928">drr</A>‌</P></BODY></HTML> Tue, 25 Apr 2017 14:08:22 GMT https://community.qlik.com/t5/QlikView/Generate-Load-Scripts-with-TSQL-Meditech-DR/m-p/1316115#M618379 Tanalex 2017-04-25T14:08:22Z