Forum Discussion

JulianaMacedo's avatar
JulianaMacedo
Helper II
4 years ago
Solved

Missing Field.Ignore

Hi! I'm trying to use this Missing Field Ignore in a step I created, but I'm getting an error and I couldn't figure out why. The data is basically a table with a column with numbers as strings like...
Need Help
jennratten's avatar
jennratten
Super User
4 years ago

Hello - please try this...

 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjQwACKCQClWJ1oprzQnB8wgoEkpNhYA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    Source1 = Table.ReplaceValue(Source,"null",null,Replacer.ReplaceValue,{"Column1"}),
    // replace this list with your list of column names
    #"List of Columns to Create" = {"Column1.1", "Column1.2", "Column1.3", "Column1.4", "Column1.5"},
    #"Split Column by Position" = Table.SplitColumn(Source1, "Column1", Splitter.SplitTextByRepeatedLengths(8), #"List of Columns to Create")
in
    #"Split Column by Position"

 

 

  • JulianaMacedo's avatar
    JulianaMacedo
    Helper II
    4 years ago

    Hi! Thanks for your contribution, I actually tried the other suggest solution first and it seems to be working fine, so I haven't tried yours, but it also seems like it would be a suitable solution.