Forum Discussion
Changing mismatch 'Blank' with text
Hi, I want to create a visual that is using data from 3 related tables but encountered some mismatch issue. The sample tables look like this: Table A Item Number Volume a 10 a 5...
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.
Hariharan_R
Solution Sage
Solution SageHi,
To achieve this in simple way, you can uncheck the blank on the visual filter.
Thanks
Hari
Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.
My Blog :: YouTube Channel :: My Linkedin
If I helped you, click on the Thumbs Up to give Kudos.
My Blog :: YouTube Channel :: My Linkedin
Hi Hari, thank you for your reply. I'm tyring to replace the "blank" with the text "unknown" but not to hide it. Do you have any suggestion on that?