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?
how did you check on the blank column values? Were you using the first 1000 records (bottom left you can change to entire data set).