0 Replies Latest reply: Apr 2, 2018 3:33 AM by ali aliali RSS

    Qliksense load from stored procedure not working

    ali aliali

      Hi,

       

      I have a stored procedure returning a table variable.

      İnside Stored procedure i am declaring a table variable as

      DECLARE  @Result TABLE

      (

            CUSTOMER NVARCHAR(50),

            MATERIAL NVARCHAR(50) ,

        ORDERS int,

        STOCK int,

        DATE1 datetime  

      )

      at the end of the procedure i'm returning table variable as

       

      SELECT * FROM @Result

       

      and stored procedure returns a resultset.

      I want to get this results into Qliksense

       

      I've already tried

      -------------

      Load *;

      SQL execute dbo.stored_procedure;

      -------------

      STOCK:

      LOAD

      CUSTOMER AS %KEY_CUSTOMER,

      MATERIAL AS %KEY_STOCK,

      MATERIAL AS %KEY_MATERIAL,   

      ORDERS AS ORDERS,

      STOCK AS STOCK,

      Floor(NUM(DATE1))  AS [%KEY_CALENDAR];

      SQL EXECUTE QlikSense.dbo."myproc";

      -----------------

       

      result are allways empty.

       

      Any suggestions will be much appriciated.

      Thank you.