Forum Discussion
Error Message (Blank Values)
Hi Community - I attempted to merge two tables using a primary column such as TicketID that the both tables already have. What I had done was that I set up was "merge queries" by using a small d...
If you go in the Query editor and check the column profile?
In this example I have a table with 1100 rows, first 1000 are ok. I the column distribution you'll find no blanksHowever, when switching to full dataset the blank comes out int he profile:
Perhaps you're experiencing something different, but it's already a good check of your data.
Did you select the correct columns to join on in the merge? How do you define a blank for a text colum?
hi Anonymous
if many side of the column has items that are not present at the one side of the relationship, then blank value will be added automatically at the one side.
is it what you are facing now?