0 Replies Latest reply: Apr 25, 2017 10:08 AM by Michael Armentrout RSS

    Generate Load Scripts with TSQL (Meditech DR)

    Michael Armentrout

      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