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] )

mhawkinsCU's avatar
mhawkinsCU
Frequent Visitor
4 years ago

It needs to be in the field_values table. 

mhawkinsCU's avatar
mhawkinsCU
Frequent Visitor
4 years ago

so basically what I am trying to have show in the Employee type column is - this is the field_values table

take the id 89088567

look on the field_value_choices table - match the id to teh field_value_id and return teh field_choice_id - 160597

 

 

 

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Ok

    then try

    MAXX (

    RELATEDTABLE ( field_value_choices ), field_value_choices[field_value_id] )

  • mhawkinsCU's avatar
    mhawkinsCU
    Frequent Visitor
    4 years ago

    That worked when I changed it to 

    MAXX (

    RELATEDTABLE ( field_value_choices ), field_value_choices[field_choice_id] )
  • mhawkinsCU's avatar
    mhawkinsCU
    Frequent Visitor
    4 years ago

    It does appear there are duplicate values in the field_value_id column as there are 7,444 rows but only 6,315 distinct values.

     

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    But the field value choices table is the many side which means that for some ID's (at least one) you have multiple matches. Otherwise, the relationship would be one to one not one to many. And this is the source of the error in your formula. It could be blanks that is causing the issue. You need to double check your source data