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.
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. |