Forum Discussion
Changing mismatch 'Blank' with text
Anonymous you need to have something that will represent the values in table A also in table B (and in this case also table C cause they are in 1:1 so they actually should be 1 table). If you replace the null with unkonwn you also need to have the same unknown text in table B also with unknown text for category number and also in table C unkonwn text on the values of the new row you need to add.
Better to join table B and C before you bring it to the model, then you will need to do that only on one table.
Community ChampionAnonymous the blank appears when you have records in the many side of a relationship that doesn't have a matching key in the table at the one side. You can't replace it. You should always strive to have a model that each row in the many side has a represntative in the one side. Can you share a screenshot of the model view and write what columns play in the relationship.
Hi, thank you very much for the help! The relationship look like this:
There are null value in table A. Table B&C don't have any null value.
- SpartaBI
Anonymous you need to have something that will represent the values in table A also in table B (and in this case also table C cause they are in 1:1 so they actually should be 1 table). If you replace the null with unkonwn you also need to have the same unknown text in table B also with unknown text for category number and also in table C unkonwn text on the values of the new row you need to add.
Better to join table B and C before you bring it to the model, then you will need to do that only on one table.