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 form...
  • tamerj1's avatar
    tamerj1
    4 years ago

    Ok

    then try

    MAXX (

    RELATEDTABLE ( field_value_choices ), field_value_choices[field_value_id] )

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

       

      • tamerj1's avatar
        tamerj1
        Community Champion
        4 years ago

        Great

        would you please answer the question at end of my previous reply