mapping

Mon, 07 Dec 2015 10:23:19 GMT

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...

Re: mapping

Tue, 08 Dec 2015 00:40:08 GMT

Any answer?