Multiple values in a column

1

Hi,

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?

Thanks,
Steve

2

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)