8 Replies Latest reply: Dec 19, 2013 10:59 AM by Antoine Frangieh RSS

    QV not reading the correct field value due to similar values

    Antoine Frangieh

      Hello Friends,

       

      I am faced with a nasty bug, that I am unable to solve.

      HEre is the scenario:

      T1:

      LOAD * INLINE [

      f1, f2

      A,85
      B,1
      C,4
      D,2
      E,35
      F,11
      G,11
      H,4
      I,27
      J,5
      K,1
      L,5
      M,1
      N,1

      ]

      ;

       

      Now I want to count the field values of each occurence and store in a variable to reuse later on.

      LET j = NoOfRows('T1');

             

              FOR i = 1 to $(j)

             

                  LET vLines$(i) = FieldValue('f2',$(i));

             

              NEXT;

       

      It is failing to assign values for similar fields.

       

      Any thoughts on the matter?

       

      Thanks,

       

      Antoine