2 Replies Latest reply: Aug 4, 2014 11:33 AM by Joe Crane RSS

    How to replace all fileds with their corresponding keys

    Joe Crane

      I have these two tables:

       

      Table1:

       

      1.png

      Table2:

       

      2.png

       

      I want to replace all of the YearEvents and YearEventKey_Grouping with their corresponding key... so for example replace all 2009 WTS with a 1. all 2011 WTS with a 2... etc.

       

      Thanks!