Forum Discussion
Help needed with transforming a column with two types of numeric values
Hello all!
Apologies if this has been covered before, but I could not find a suitable answer. I am transforming data in Power Query that relates to sick leave percentages and hours. In a query, I have a column that includes values for both. Is there a way to separate them quickly? A functionality that I have not thought of? There are five types of time events that include the aforementioned values: sickness hours, accident hours, theoretical hours, sick leave % and accident absence %. How to separate the numbers for sick leave % and accident absence % from the rest?
Attached is a snapshot of the table so you get the idea.
Cheers for your help and for this forum,
Jani
You could add a subcategory column with an if statement in Power Query, similar to
if List.Contains({"sick leave", ...........},[event column....]) then "a" else "b")then Pivot (from the Transform menu) the new subcategory column.
I've only given you some of the syntax for the column so you can complete it
3 Replies
- HotChilli
Community Champion
You could add a subcategory column with an if statement in Power Query, similar to
if List.Contains({"sick leave", ...........},[event column....]) then "a" else "b")then Pivot (from the Transform menu) the new subcategory column.
I've only given you some of the syntax for the column so you can complete it
- AlexisOlson
Super User
I'm not quite sure what you want the result to be after "separation".
If you want it to look something like this, then go with HotChilli's suggestion:
If not, then you'll need to specify what the desired result should be.
