Spotfire Ideas Portal
When joining tables in Spotfire, add an option where empty values are treated as wildcards. There's the option for "Treat empty values as equal" but this would only return the case if both tables had empty values for the matched field. If the value is empty in one table for one or more matched fields, I want the case returned regardless of the value in the other table for the field(s) with the empty value as long as the other matched fields with non-empty values match.