Forum Discussion
IF and PATH in Calculated Column
Here is a much faster version
Hi lbendlin
Tried the idea of joining the table onto itself, but then I couldn't get the output correct. Probably due to operator error on my part.
But I did come up with another solution to this... First, took the field of valid WorkItemIDs and turned it into a list. Then added a custom column like this
Thank you for your help!
Ok. I've never been a fan of adding columns for a calculation and deleting the original. Creates lots of additional steps that really don't need to be there. So I reworked the solution I provided earlier. Now it replaces the value if the List.Contains finds the ParentWorkItemID value in a list of Valid WorkItemIDs. Thing about this solution is that it was painfully slow. More than 15 minutes to import about 6.2k records.
Modified slightly to add a step to List.Buffer the valid WorkItemIDs in memory and then perform the List.Contains step. Went from 15ish minutes to seconds.
Here is a much faster version
Hi lbendlin
Tried the idea of joining the table onto itself, but then I couldn't get the output correct. Probably due to operator error on my part.
But I did come up with another solution to this... First, took the field of valid WorkItemIDs and turned it into a list. Then added a custom column like this
Thank you for your help!
Ok. I've never been a fan of adding columns for a calculation and deleting the original. Creates lots of additional steps that really don't need to be there. So I reworked the solution I provided earlier. Now it replaces the value if the List.Contains finds the ParentWorkItemID value in a list of Valid WorkItemIDs. Thing about this solution is that it was painfully slow. More than 15 minutes to import about 6.2k records.
Modified slightly to add a step to List.Buffer the valid WorkItemIDs in memory and then perform the List.Contains step. Went from 15ish minutes to seconds.