Mapping individual array values to new values based on a lookup table

David Lang 40 Reputation points
2024-06-05T17:59:20.6233333+00:00

In Azure Data Factory, how can I perform a lookup on each item in a string array or line of delimited text to map each item to a new value? I have a set of codes in one column. I would like to map these codes to their descriptions and have the descriptions end up in another column in the same format. I have a dataset that contains rows with each code and description on separate lines. How can I use the dataset to map each code to its description?

e.g.["SG", "DB", "TP"] map to ["single", "double", "triple"]or

"SG"~"DB"~"TP" map to "single"~"double"~"triple"

My lookup table:

Code Description
SG single
DB double
TP triple
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,949 questions
{count} votes