Forum Discussion
Solved
How to condense into one table with only one value
I have this table that I don't want to change the order, want to generate a table with the logic where if any active for same CFN outcome will be active, if no all discontinue or no active then outcome is Discontinue
| CFN | GTIN | DCHAIN | GTIN Status |
| A | 1 | DR | Active |
| B | 5 | X0 | Discontinue |
| B | 8 | XX | Discontinue |
| D | 7 | OI | Active |
| E | 11 | X0 | Discontinue |
| B | 4 | X1 | Active |
| D | 9 | PP | Discontinue |
| E | 10 | PP | Discontinue |
| A | 3 | XX | Discontinue |
| D | 7 | OI | Active |
| B | 6 | PP | Discontinue |
| E | 12 | 99 | Discontinue |
| E | 13 | XX | Discontinue |
| A | 2 | X1 | Active |
| OutCome | |
| CFN | CFN Status |
| A | Active |
| B | Active |
| D | Active |
| E | Discontinue |
- CFN Outcome
A Active Discontinue Active Active
B Discontinue Discontinue Active Discontinue Active
D Active Discontinue Active Active
E Discontinue Discontinue Discontinue Discontinue Discontinue
1 Reply
- CFN Outcome
A Active Discontinue Active Active
B Discontinue Discontinue Active Discontinue Active
D Active Discontinue Active Active
E Discontinue Discontinue Discontinue Discontinue Discontinue