Forum Discussion
Column with multiple conditions
Good Morning 🙂 I am struggling with creating a column/conditional column Conditions: ● BD: TR Type = CRD, TR Code = 123, BK Trx # = 41, TR Text Does Not Contain "DCD" ● MD: TR Type = CRD, TR Co...
| TR Type | TRCode | BKTrx # | TR Text |
| CRD | 456 | 1.91E+13 | ST |
| CRD | 123 | 41 | DCD |
| CRD | 123 | 41 | DCD |
| CRD | 123 | 1 | DCD |
| CRD | 123 | 41 | DCD |
| DBT | 123 | 1 | DCD |
| DBT | 123 | 41 | DCD |
Here is a sample data set.