Forum Discussion
ghaines
Resolver I
Resolver IBest way to approach some data
I'm working with some data that records a primary failure reason ID in one column, and other failure reason IDs as CSV in another column. The primary failure reason may or may not be represented in ...
You could
List.RemoveItems(Text.Split([Failure Reason], ","), {[Primary Failure Reason]})
Then add a suffix to the primary reason like ":P"
Combine into a list, split to new rows, split by ":" into columns.
The rows with the "P" in the new column are the primary reasons.
spinfuzer
Solution Sage
Solution SageYou could
List.RemoveItems(Text.Split([Failure Reason], ","), {[Primary Failure Reason]})
Then add a suffix to the primary reason like ":P"
Combine into a list, split to new rows, split by ":" into columns.
The rows with the "P" in the new column are the primary reasons.
- ghaines
And with this I could reliably set where the primary failure reason appears. Thanks!