Forum Discussion
Solved
Create conditional column by delimiting at different points based on keywords
I am parsing through reported crime dataset where the [Attribute] column contains details on the type of crime and what type of data point it is. Using Assault as an example, there is a datapoint...
I would type this in the formula bar:
= Table.AddColumn(PriorStepName, "TypeOfCrime", each if Text.Contains([Attribute], "Assault_Rate") then "Assault_Rate" else if Text.Contains([Attribute], "Assault") then "Assault" else [Attribute])
--Nate