Hello,
I have in interesting challenge to solve today. I am trying to map two sets of picklist values together. Basically I have one picklist which contains Data.com industry values, and a second picklist that contains a set of industry values that are very specific.
I am looking to replicate what a CASE statement does, but I have too many values to use a CASE statement.
I would like to store a "fixed" mapping and then somehow reference it in a flow - so that if picklist A has a value of "Agriculture" my flow can consult the mapping guide and return "Agronomy, Agriculture, and Crop Production", and update picklist B with that value.
Thanks in advance, I hope I asked this in a way that makes sense.
8 answers
How many values are there?
It sounds like this should be fine. There are probably ways to decrease the search time. IE bypassing a node of comparisons.
