Create new dimension with multi condition in the Script

[ericheleine]

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"]