Forum Discussion

mhawkinsCU's avatar
mhawkinsCU
Frequent Visitor
4 years ago
Solved

LOOKUPVALUE error

I am getting the "A table of mulitpule values was supplied were a single value was expceted."

I am trying to look up the field_value_choices[field_choice_id] based on the field_values[id]

This formula is being used in a calculated column. 

I am stuck as to way I am getting this error.

 

 

Here is my formula 

Employee Type= LOOKUPVALUE(field_value_choices[field_choice_id],field_value_choices[field_value_id],field_values[id])

 

field_values

field_value_choices

 

  • tamerj1's avatar
    tamerj1
    4 years ago

    Ok

    then try

    MAXX (

    RELATEDTABLE ( field_value_choices ), field_value_choices[field_value_id] )

17 Replies

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Hi mhawkinsCU 

    it seems that the field_value_choices[field_choice_id] column does no contain unique values. Please provide more details about your data model. 

    • mhawkinsCU's avatar
      mhawkinsCU
      Frequent Visitor
      4 years ago

      I have no relationships between these two tables. 

      • tamerj1's avatar
        tamerj1
        Community Champion
        4 years ago

        mhawkinsCU 

        Sorry for the late reply. 
        If possible please create a relationship between 

        field_value_choices[field_choice_id]

        and

        field_values[id]

        and let me know the cardinality and the crossfilter type you get. 
        based on that we can retrieve values using RELATED or RELATED table. 
        In case you have multiple 

        field_value_choices[field_value_id]

        for each field_values[id] then you have to advise which one of them should be retrieved 

  • mhawkinsCU's avatar
    mhawkinsCU
    Frequent Visitor
    4 years ago

    So the lookup value have to be unique? I am trying to determine the field_choice_id by checking the field_vaule_id. 

     

    What details about my data model would be helpful?