Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Enter NULL value in manual table

I was looking at how the data was being shown when imported from a database and ran some tests by just starting a new file, clicking "Enter Data", entering a sample data set and then adding the same ...
Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    Anonymous create blank query and paste this code, Id column will have null

     

    let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("Hce7FYAgEATAXjYmEFHREPFXgrzzCjCx/9B9m82YISKgwIOhp1YpUfX5qjIwt0Q0YaQ2aaJ2KVOHNFOntFCXFDvyhfsP", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Id = _t, Text = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Id", Int64.Type}, {"Text", type text}})
in
    #"Changed Type"
  • parry2k's avatar
    parry2k
    6 years ago

    Anonymous you can actually use replace function to update null value

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

So there is no easy way to do this? Would be nice if when you were in the edit source mode (where you can just type values into the table) you could right click and set to null value or something like that. Or just some graphical way that you could create a null value so that when you are messing around with test data it would be quick to change values.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

Anonymous you can actually use replace function to update null value

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I thought of that, but isn't that replacing the string "A" with a string "null" and not an actuall null?

    • parry2k's avatar
      parry2k
      Icon for Super User rankSuper User
      6 years ago

      Anonymous it will be actual null not string "null"

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        parry2k 

        Your right! Now I can just leave any cells blank in that colum I want and do a replace on that column (if I want blank strings I would just have to use a string thats nowhere else) with null. I like this solution as its a lot quicker and more flexible. Thanks for that.