Multiple values in a column


I have a column where multiple values are delimited by a “|” . I’d like to do a lookup against each value (from another table) and return the first match. Is this possible?


Yes, it’s possible. Split the delimited values into rows using Split into rows transformation, then do a regular lookup using Lookup.

See the example below:
Book3.xlsx (8.9 KB)
lookup.morph (2.2 KB)