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



      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,