5 Replies Latest reply: Feb 19, 2018 7:58 AM by Peter Cammaert RSS

    how to extract the Table name in to a field

    bhavani b

      Hi Experts,

       

      Can any one Please help me on this.

       

      From the below script how to pass QLIK from Table name into a New Application Field.

       

      LIB CONNECT TO 'Remedy-ODBC64 (John)';

      LOAD

          Client,

          Date,

          START TIME,

          END TIME;

      [PROD_QLIK]:

      SELECT  Client,

          Date,

          START TIME,

          END TIME

      FROM "USER"."PROD_QLIK";


      Please help me on how to do this.


      Thanks in advance.