Hi Friends,
I have a requirement to create two new fields using the existed fields in the dump what I have attached.
So here I have to write lot of match conditions to bring the new fields,
For example, if the below portfolio is ALM GAP and ProductCode is POSB Deposits then My output should be Other Deposits .
| Portfolio | ProductSubType | ProductCode | MappedProduct | Strike | Instrument | Mapping Value | Special Overwrite |
| ALM GAP | | POSB Deposits | | | | Other Deposits | Y |
So i want to know do we have any better solution to create the mappings instead of match().
Please find the attached excel file for the data, left side 6 fields are my input and Right side 2 feilds are my Output.
Waiting for your solutions...
