Good Morniing every one,
I need some help to find the better way to achieve the script below:
I want to create a dimension called CoverName using the following test:
1 / If the PNG_TRADE_DIRECTION is BUY, and MIFIDName least one of the fields (1,2,3,4) | MIFIDPrice (1,2,3,4) is filled.
- The CoverName field will take the value of the MIFIDName MIFIDPrice lowest.
- Otherwise the value CoverName take the value of the unique MIFIDName informed.
2 / If thePNG_TRADE_DIRECTION is SELL, and in less than a MIFIDName1,2,3,4 fields | MIFIDPrice1,2,3,4 is filled.
- The CoverName field will take the value of the MIFIDName MIFIDPrice highest.
- Otherwise the value CoverName take the value of the unique MIFIDName informed.
Script data:
Trade Direction : ["PNG_TRADE_DIRECTION"]
MIFIDName1 : ["PNG_TRADE_MIFID_NAME_1"]
MIFIDName2 : ["PNG_TRADE_MIFID_NAME_2"]
MIFIDName3 : ["PNG_TRADE_MIFID_NAME_3"]
MIFIDName4 : ["PNG_TRADE_MIFID_NAME_4"]
MIFIDName5 : ["PNG_TRADE_MIFID_NAME_5"]
MIFIDPrice1 : ["PNG_TRADE_MIFID_PRICE_1"]
MIFIDPrice2 : ["PNG_TRADE_MIFID_PRICE_2"]
MIFIDPrice3 : ["PNG_TRADE_MIFID_PRICE_3"]
MIFIDPrice4 : ["PNG_TRADE_MIFID_PRICE_4"]
MIFIDPrice5 : ["PNG_TRADE_MIFID_PRICE_5"]