Hi, Fellow community members !! I am trying to vlookup of two data set and update strings for example: I am trying to compare the column "Old trait id" to the dataset B for matches and update the matches in Dataset B by appending "New trait id" with string "OR". Dataset A NEW TRAIT ID OLD TRAIT ID 16070843T 74160T 16070844T 16981T 16070847T 79556T Dataset B segmentRule (74160T OR 16981T) AND (79556T) Output (74160T OR 16070843T OR 16981T OR 16070844T) AND (79556T OR 16070847T)
... View more