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
Icon for Community Champion rankCommunity Champion
4 years ago

Great

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

  • mhawkinsCU's avatar
    mhawkinsCU
    Frequent Visitor
    4 years ago

    If you are asking about the Cardinality and crossfilter type that is why included the Edit relationship details in the picture.

    It is many (field_value_choices) to 1 (field_values), Cross filter direction is single.  

    • tamerj1's avatar
      tamerj1
      Icon for Community Champion rankCommunity Champion
      4 years ago

      Actually no. What I mean is that there is no single value for the ID. Retrieving the ID in the the field values table will result in a table rather than a single value. Therfore, you have to provide a preference on which on of the ID's shall be selected. Unless you are sure that this table actually contains duplicates of the same ID. 

      • mhawkinsCU's avatar
        mhawkinsCU
        Frequent Visitor
        4 years ago

        I am sorry but I am not following what you are asking for.

        I am trying to use the field_values[id] in the field_values table and look up that on the field_value_choices table were 

        field_value_choices[field_value_id] 

        and return the 

        field_value_choices[field_choice_id]
         
        I am using a calcualted column so there should only be 1 field_values[id] at a time.