Forum Discussion
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...
Ok
then try
MAXX (
RELATEDTABLE ( field_value_choices ), field_value_choices[field_value_id] )
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.
I have no relationships between these two tables.
Sorry for the late reply.
If possible please create a relationship betweenfield_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 multiplefield_value_choices[field_value_id]
for each field_values[id] then you have to advise which one of them should be retrieved
