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?
I changed it to the entire dataset and I do see that there is one empty row... How do I handle this?
You can filter it out (remove blank rows in the home ribbon), or update the source to the correct ticket value.