6 Replies Latest reply: Aug 1, 2011 4:18 PM by Jorge Souza RSS

    Expression in Script

      Good day

       

      I have a data source from excel as below:

       

      PositionValue
      Qty
      1ARBUE
      2UYMVD
      Cost
      3ARBUE


      i want to create a condition that creates a third column (KEY) as below:

      if (Position = '', Value, 'an expression that copy the row above in KEY column')

      I'm not able to find this expression or any another solution for this.

       

      PositionValueKEY
      QtyQty
      1ARBUEQty
      2UYMVDQty
      CostCost
      3ARBUECost