2 Replies Latest reply: Dec 5, 2013 1:32 PM by Mark campbell RSS

    Dynamic string to Field (evaluate at each record)

      Is this even possible?  I am trying to turn a string into a field; however, depending on the dimension, the string is different.  currently I am just getting nulls returned.  the 4th column in the below is what I am trying to do; however it always returns null. 

       

      dim1      | Val_A | Val_B | $(='Val_' & dim1)

      A           | 4.5     | 3.1     | 4.5

      B           | 2.1     | 1.7     | 1.7