2 Replies Latest reply: Feb 21, 2014 6:00 AM by Daniel Sturesson RSS

    Cross referencing in script

      Hi!

       

      I'm sure that I'm creating a post that there already is an answer for but I can not find it.

       

      I have a table that looks like the one below. What i want to do in the script is to look at the parent ID field. If there is a value I want it to find that row based on the ID field, copy the region value and put it in the region field for the row that has a parent ID.

       

      So, in this example I want Norway to inherit the region value Europe from its parent Sweden.

       

      IDCOUNTRYREGIONPARENTID

      1

      SwedenEurope
      2Norway1
      3ChinaAsia

       

      Any help would be much appreciated.