Forum Discussion
navedkhan
Helper III
Helper IIIRemove 'Closed' status workitems completely from table
Hi - i need quick help with identifying those work items which have a 'Closed' status and then removing that work item number compltely (whether it's pending or active status) from analysis. W...
Hi navedkhan ,
As a supplement to DataZoe , check the following steps.
1# Copy and paste table1 as table2.
2# Filter rows in table2 which column status is closed.
3# Remove status and datetime column in table2.
4# Merge table1 and table2 with left anti jion.
5# Remove columns from table2 in merge table.
Best Regards,
Jay
Hi navedkhan ,
As a supplement to DataZoe , check the following steps.
1# Copy and paste table1 as table2.
2# Filter rows in table2 which column status is closed.
3# Remove status and datetime column in table2.
4# Merge table1 and table2 with left anti jion.
5# Remove columns from table2 in merge table.
Best Regards,
Jay