Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Generate Load Scripts with TSQL (Meditech DR)

Thought I would give back to the community that has been an immense resource for me.  About a year ago I created the attached TSQL scripts that generate Qlik LOAD commands for any number of tables in a Microsoft SQLServer database.  The places to alter are the WHERE clauses to further filter the result set(s).  Also, change the STORE/FROM lines to reflect your relative path location.  If there are any questions, or opportunities to improve, please let me know.  Thank you!

This was prompted by a posting  "Show Me the Data"‌ by Dalton Ruer - drr