Skip to main content
John Neff (Ring2Media) 님이 #Data Management에 질문했습니다

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개
  1. 2017년 3월 26일 오후 5:45
    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. 
0/9000