Is your blend/fields which are creating the relationship working the same way in all your sheets?
Maybe try using a trim to remove any spaces before and after the field.
Will do some deeper dives into the data itself.
Is there a way to show all of the characters in a field in Tableau??? Data Types - ASCII vs, UNICODE
can you share sample excel file for validate..?
This is the short list, the full list does the same randomly returning "Null"
I've tried to edit the Excel file and remove the trailing "space" - didn't help
Yes, attached is the short version of the list, 2 of the program names match perfect, 2 others return Null.
I've tried joins using the source data in Tableau to the imported file and vice-versa.
here you go.
Applied Inner joins for all the three sheets like below.
Output from three sheets:
Link for your reference.
That looks like the solution, is the table joins.
Thank you so much!