1 Reply Latest reply: Jun 11, 2017 7:08 PM by Fei Xu RSS

    how to load SQL Functions into Sense?

    Fei Xu

      Can anyone help me with this please?

       

      I have had a look at this discussion at Call a function in SQL LOAD but still don't understand.

      I would like to use an example so if I have a SQL function called v_PNL, how can I load the data into Sense? What is the script in Sense data load editor?

       

       

      v_PNL (@nmonth int, @year int, @lastYear int)

      SELECT * from v_PNL (11, 2017, 2016)

       

       

       

       

       

      Thank you very much!

       

      Cheers

       

       

      Fei