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 outco...
- CFN Outcome
A Active Discontinue Active Active
B Discontinue Discontinue Active Discontinue Active
D Active Discontinue Active Active
E Discontinue Discontinue Discontinue Discontinue 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
A Active Discontinue Active Active
B Discontinue Discontinue Active Discontinue Active
D Active Discontinue Active Active
E Discontinue Discontinue Discontinue Discontinue Discontinue