15 Replies Latest reply: Aug 16, 2016 3:45 AM by Richard Chilvers RSS

    Scripting Issue

    Ben Vozza

      Hi,

       

      I am wondering if there is a way to take in the first 3 columns in the below tables, and get an output of the 4th.

      Basically each case has a list of related entities, that produce multiple rows in the table. If one of the entities for a case

      is an american entity, then I want to have a flag in each row of that case saying it is an american case.


      Any ideas of how this can be done?

      Maybe some kind of for loop?

       

       

       

      CaseEntityAmerican EntityAmerican Case
      1LondonNY
      1New YorkYY
      2ParisNN
      2LondonNN
      2Hong KongNN
      3San FranciscoYY
      3TexasYY
      3New YorkYY
      4BarcalonaNY
      4LondonNY
      4Los AngelesYY