• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Null values issue in Power Query

SbusyCR

New Member
Hi Champions!

Please refer to the attachments. I am not able to upload the two source files.

Once I change the Data Type to text in forum.xlsx in the Word # from the beginning of the Quran.2 column I am able to replace "null" for no text. However, because I need this column as Whole Number Data Type, when I go back to Whole Number, the "null" shows again.

How can I solve this?
 

Attachments

  • forum.xlsx
    19.5 KB · Views: 3
  • forum 2.PNG
    forum 2.PNG
    10.8 KB · Views: 1
It's bit difficult to help you without sample. I'd recommend uploading small file that is representative of your source file(s). 20 or so rows each should be enough.

In general, if it's "null" in italics and in small case, it's true null and you shouldn't have to worry about it. Is there any particular reason you don't want the null value?
 
Thanks for stepping in Chihiro! Smaller files attached.
 

Attachments

  • Three forum.xlsx
    9.8 KB · Views: 2
  • Two forum.xlsx
    9.7 KB · Views: 2
So what should "null" be? Should it be 0? Or blank?

If it's blank. Just leave it as is. When you load to sheet, or evaluate it in Data model. It will be treated as blank.
64203
 
Back
Top