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