2 Replies Latest reply on Jun 17, 2012 2:38 PM by Joe Mako

    Lookup into other rows with calculated field

      lookupintootherrows.jpg

       

      The first 4 columns are what I have now, would like to create a calculated field that, per row, finds matching artist by artistID and puts its country in the new column. Tried RAW commands and they didn't seem to be the right way to go about this.

       

      The use case might not quite make logical sense here as I've altered its nature to not violate company privacy. The actual nature of the data makes this make sense, so please ignore that minor fact

       

      Thanks in advance!!