Forum Discussion
ChirSidh
Helper II
Helper IIUnique Filter with threeway matching - New Column
My data set has a Category (Project Number), Sub Category (Work order number), Close Status ( True/False). One project has many work orders, what i would like to filter is If all the work orders of ...
ChirSidhHelper II
Helper II Project Work Order No Close? Expected Result
82100251 82100251-012 FALSE 82100251
82100251 82100251-012 FALSE
82100251 82100251-013 FALSE
82100251 82100251-014 FALSE
82100251 82100251-015 FALSE
72103803 72103803-159 TRUE
72103803 72103803-163 TRUE
72103803 72103803-178 TRUE
72103803 72103803-184 TRUE
72103803 72103803-189 TRUE
72103803 72103803-197 TRUE
72103803 72103803-200 TRUE
72103804 72103804-189 TRUE 72103804
72103804 72103804-197 FALSE
72103804 72103804-200 TRUE
90005981 90005981-100 TRUE
90005981 90005981-400 TRUE
90009205 90009205-105 FALSE 90009205
90009205 90009205-106 TRUE
90009205 90009205-107 TRUE
| Project | Work Order No | Close? | Expected Result |
| 82100251 | 82100251-012 | FALSE | 82100251 |
| 82100251 | 82100251-012 | FALSE | |
| 82100251 | 82100251-013 | FALSE | |
| 82100251 | 82100251-014 | FALSE | |
| 82100251 | 82100251-015 | FALSE | |
| 72103803 | 72103803-159 | TRUE | |
| 72103803 | 72103803-163 | TRUE | |
| 72103803 | 72103803-178 | TRUE | |
| 72103803 | 72103803-184 | TRUE | |
| 72103803 | 72103803-189 | TRUE | |
| 72103803 | 72103803-197 | TRUE | |
| 72103803 | 72103803-200 | TRUE | |
| 72103804 | 72103804-189 | TRUE | 72103804 |
| 72103804 | 72103804-197 | FALSE | |
| 72103804 | 72103804-200 | TRUE | |
| 90005981 | 90005981-100 | TRUE | |
| 90005981 | 90005981-400 | TRUE | |
| 90009205 | 90009205-105 | FALSE | 90009205 |
| 90009205 | 90009205-106 | TRUE | |
| 90009205 | 90009205-107 | TRUE |