13 Replies Latest reply: Oct 11, 2016 7:46 AM by krishna m RSS

    using function Qualify and Unqualify Statment

    krishna m

      please give answer to use PEEK or any function within Qualify and Unqualify statement. below is eg script

       

      QUALIFY *;

       

      funcPEEKtbl:

      LOAD Year,

           Sales,

           PEEK(Sales) As PeekfuncWrk

      FROM

      Book1.xlsx

      (ooxml, embedded labels, table is Sheet1);

       

      UNQUALIFY *;

       

      result is NULL as done with below experiments

      1. PEEK(Sales) As PeekfuncWrk

      2. PEEK('Sales') As PeekfuncWrk

      3. PEEK(funcPEEKtbl.Sales) As PeekfuncWrk

      4. PEEK('funcPEEKtbl.Sales') As PeekfuncWrk

      5. PEEK(funcPEEKtbl.Sales,-1,funcPEEKtbl) As PeekfuncWrk

      6. PEEK('funcPEEKtbl.Sales',-1,'funcPEEKtbl') As PeekfuncWrk

       

      but PEEK function works correctly without Qualify statment