Forum Discussion
LOOKUPVALUE error
Ok
then try
MAXX (
RELATEDTABLE ( field_value_choices ), field_value_choices[field_value_id] )
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.
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
and return the
Ok
then try
MAXX (
RELATEDTABLE ( field_value_choices ), field_value_choices[field_value_id] )
That worked when I changed it to
MAXX (RELATEDTABLE ( field_value_choices ), field_value_choices[field_choice_id] )The new column will be in which table?
It needs to be in the field_values table.
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
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.
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