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