3 Replies Latest reply on Nov 20, 2013 4:44 PM by Shawn Wallwork

    How do I use a field name as a variable?

    Kate Lemieux

      I have several tables which I am trying to join and and running into a issue because one tables has the variable in another tables as the field name.

       

      If I have the two tables below but want to report Application Results by Control area then I can't seem to get it to join properly because the Control names are in the field names of one of the tables.

       

      ApplicationControl 1Control 2 Control 3
      ABCCompliantCompliantCompliant
      DEFNot CompliantCompliantCompliant
      GHICompliantNot CompliantCompliant

       

      ControlControl Area
      Control 1Area 1
      Control 2Area 2
      Control 3Area 3

       

      Thanks!