Hi,
| LogicalCode | FIELD1 | FIELD2 | FIELD3 | FIELD4 |
| 44111002 | MC | IN | RF | |
| 44111002 | MC | IN | RFLCE | |
| 44111002 | MC | IN | RFLCEFULL | |
| 44111002 | MC | IN | CPGN | |
| 44111002 | CR | IN | GOODWL | |
| 44111002 | CR | IN | ECPRF | |
| 44111002 | CR | IN | MCPRF | |
| 44111002 | CR | IN | MIRF | |
| 44111002 | CR | IN | ROAMRF | |
| 44111002 | CR | IN | SMSRF | |
| 44111002 | CR | IN | OTTRF | |
| 44111002 | CR | IN | OFVC | |
| 44111002 | LN | IN | | |
| 44111002 | LN | RD | | |
| 44111002 | WB | CC | | |
| 44111002 | UD | CC | | |
| 44111002 | FS | CC | | |
| 44111002 | RP | CC | | |
| 44111002 | CO | CC | | |
| 44111002 | WB | BN | | |
| 44111001 | FS | BN | | CIMB-EPK |
| 44111001 | FS | BN | | PBB |
i have a straight table in that field1 feild2 feild3 are there and i want to add logical code but i want to show logical code based on feild4 value if it is null go for feild3 if it is also null feild2 but the logic is need to create dynamically that means in future they add the feilds then also works from field5 then field4 like that
for example :
field4 have null in first record so went to field3 RF logical value is 441111002
field 4 have the value PBB directly show 44111001
in future may add one more field5 it needs to compare the same dynamically without writing the logic again
