SQL Insert from QlikView.qvw

    In this app I showed how to insert data into SQL Table by LOAD Script or using macro. Data from variables insert into SQL Table by this script:

     

    INSERT INTO [dbo].[Table1]

               ([Param1]

               ,[Item1]

               ,[Item2])

         VALUES

               ('Listen', 'to', 'Skrillex')

     

    For this task i used variables named like columns in my SQL Base.

    Name of base: QlikViewBase

    Variables: Param1, Item1, Item2

     

    You can surely modify my creation and use it by your own purposes. Just say thanks to me and remember my name.