Forum Discussion
CharlotteCity12
4 years agoMicrosoft Employee
Create two columns from one column breaking out numbers from text
Working with a data set where one column consists with either number or text ( see below). How can I separate the text from number in different column? I have tried “column example” /changing data ty...
- Anonymous4 years ago
How about adding columns instead?
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtQzsFCK1YlWMtCzhNJmYNrRD0yZQjhuSrGxAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [#"Concentration/Null Code" = _t]), #"Added Custom" = Table.AddColumn(Source, "Concentration", each try Number.From([#"Concentration/Null Code"]) otherwise null), #"Added Custom1" = Table.AddColumn(#"Added Custom", "Null Code", each if [Concentration] = null then [#"Concentration/Null Code"] else null) in #"Added Custom1" - 4 years ago
Thank you Anonymous This worked perfectly.
CharlotteCity12
4 years agoMicrosoft Employee
Thank you Anonymous This worked perfectly.