Forum Discussion
Split a column containing specific intervals
Hi all, I'd like some help on splitting a column into two columns containing specific data. Right now, the column looks like this: after the numerals, there's specific abbreviations: ST & ...
Anonymous
Looks like your current last step is called #"Removed Columns2". If so, you'd need to add the steps after (in the Advanced editor), making sure the first step "col_" reads from the correct step and column:
col_ = #"Removed Columns2"[Column7], KG_col = List.Select(col_, each Text.Contains(_, "KG")), ST_col = List.Select(col_, each Text.Contains(_, "ST")), res_ = Table.FromColumns({KG_col, ST_col}, {"KG", "ST"}) in res_If this does not work, do share your pbix
Please accept the solution when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Hi Anonymous
Place the following M code in a blank query to see the steps.
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlTwdleK1YlWMtIzUggOATPBhDFMwkTPBEXCFCZhBhaOBQA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}),
col_ = #"Changed Type"[Column1],
KG_col = List.Select(col_, each Text.Contains(_, "KG")),
ST_col = List.Select(col_, each Text.Contains(_, "ST")),
res_ = Table.FromColumns({KG_col, ST_col}, {"KG", "ST"})
in
res_
|
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
Hi,
Many thanks for the quick response! Would you be willing to go a little more in-depth as to what and where I have to place the M code to get my desired outcome (I'm very new to this)?
This is the situation as a whole.
Thanks again!