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

     

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.