4 Replies Latest reply: Feb 1, 2017 10:00 PM by Madhur Mehrotra RSS

    Load Data from a Script Variable in Qliksense

    Madhur Mehrotra

      Hi

      Im trying to load data from a variable in qlikview which is working fine but same code is not working in qliksense.

       

      We load some data from a url which we store in a variable but same variable is not working in qliksense script. It gives me an error

      The following error occurred:

      LOAD statement only works with lib:// paths in this script mode...

       

      Here is the sample code which i am trying to load.

       

      LIB CONNECT TO 'GWMMISDEV (naeast_d281410)';

       

       

      //Gets user list from the link

      USER_LIST:

      SQL

      SELECT mis_app,

          xml_urls as url

      FROM Schema.table_dim a

      Where a.col1 ='ABC';

       

      LET vUser = if(isNull(peek('url',0,'USER_LIST')),1,peek('url',0,'USER_LIST')) ; 

       

      FNCTNL_ENTTL:

      LOAD

           @13:19 as 'StandardId',

          'ABCDEr' as 'Function_Entl'  // Key to parent table: WmUisEntitled

      FROM $(vUser)

      (fix, codepage is 1252);

      WHERE @1:12 = '<StandardId>';

      Exit Script;

       

      Loading data from v(user) is not happening in qliksense.

       

       

      Above code work perfectly fine in qlikvew but not in qliksense.. do we have the workaround for this