Forum Discussion
Error when using a column to sort another column
I have a list of values in a filter that need to be sorted. I created a sort table: I joined it to my table: I created a new column in my data table "Location_SortB = related('Alt L...
The problem is the relationship. Because it is a one-to-many, that could result in a blank row being silently added to the one-side in the event that rows appear in the many side which don't exist in the one-side.
You can try deleting the relationship and instead of using RELATED use LOOKUPVALUE instead.
That might not work, again because of possible blank values in the lookup table. If that is the case you would need to create the sort order column directly on the target table, probably using SWITCH to define logic.