8 Replies Latest reply: Feb 18, 2013 6:04 AM by Joe Kirwan RSS

    Creat new field combining other fields, conditional on combined value previously loaded in inline table

    Joe Kirwan

      Hi

       

      In my load script, I want to create a new field combining a number of other fields, but depending on the value of the combined fields.

       

      If the value of the combined fields exists in a previously loaded inline table, the new field will have a certain value. If it does not exist, it will have a different value.

       

      So in my inline table, I have a field name X, which contains values A&B&C.

       

      In my script, I combine Fields A, B and C. If A&B&C exist in the inline table, value is A&B&C. If not value is A&Other.

       

      I hope this explains my problem,

       

      Tks

       

      Joe