6 Replies Latest reply: Apr 10, 2015 6:43 PM by Christian Germeroth RSS

    Search for equal field in other column

      Hallo Community,

       

      i have a Scripting Problem and am searching for help.

       

      my data structure looks like that:

       

      Column A, Column B, Column C

      1, 0, 99

      2, 1, 999

      3, 4, 9

      4, 6, 9999

      5, 2, 99999

       

      within the script I want to:

       

      Load

      Column A,

      "search for value in of column A in column B and return the value of column C" as Value

      From xxx;

       

      The Table in my App should look like:

       

      Column A, Value

      1, 999

      2, 99999

      3,

      4,

      5,

       

      Thanks for any help in advance!!

       

      Chris