0 Replies Latest reply: Mar 20, 2012 1:51 PM by Sushil Kumar RSS

    how do i create no of variable according to row count of a table?

    Sushil Kumar

      Hi all ,

       

      I have a table. i want to create as no of variable depending upon no of rows in table..

       

      My script is as given below.

       

      Data_Table:

      Load

      Test

      Measure

      from GG_tab.qvd

       

      let vcount= NoOfRows('Data_Table');

       

      suppose vcount comes to be 6 in no....and data in my DATA_TABLE is like given below

       

      Test
      Measure
      T1M1
      T2M2
      T3M3
      T4M4
      T5M5
      T6M6

       

       

      Then how can i create 6 variables like

       

      T1_M1_V1

      T2_M2_V2

      T3_M3_V3

      T4_M4_V4

      T5_M5_V5

      T6_M6_V6

       

      Please help me to solve this problem

       

      Thanks

      sushil