6 Replies Latest reply: Oct 19, 2017 11:11 AM by omar bensalem RSS

    Store Qlik Sense table from Qlik Script into an Sql database

    omar bensalem

      Hi everybody, sinanozdemir

       

      What I want to do is creating a table in the script and then store it (all of its fields into a database)

      I've got inspired by this:

      Capture.PNG

       

      Can you confirm that this would work?

       

      alerts:

      load Alert inline [

      Alert

      alert1

      alert2

      alert3

      ];

       

      lib Connect To databaseName;

      FOR Each a in FieldValueList('Alert')

      dim:

      let vAlert = a;

      sql use databaseName

      exec writeBack'$(vAlert)';

       

      NEXT a


      Thanks