Mapping based on field value

[Anonymous]

Hi all,

I need to do some mapping based on column value.

For example,

if column A equals "1", then select value of column B,

if column A equals "2", then select value of column C, etc.

I used tMap component and expression like:

(
((String)globalMap.get("typeCodeId")).equals("8") ? row21.primaryActivityCode : ((String)globalMap.get("typeCodeId")).equals("2") ? row2.kpp : 
((String)globalMap.get("typeCodeId")).equals("6") ? row2.okato :
((String)globalMap.get("typeCodeId")).equals("1026") ? row2.okpo :
((String)globalMap.get("typeCodeId")).equals("1019") ? row2.oktmo :
((String)globalMap.get("typeCodeId")).equals("4") ? row2.okopf : 
((String)globalMap.get("typeCodeId")).equals("5") ? row2.okfs : 
((String)globalMap.get("typeCodeId")).equals("7") ? row2.okogu : ""
) 

Are there any hacks to do such mapping in more convenient manner?

e.g. using BRMS or decision tables.

Any advice would be appreciated

[manodwhb]

@Mstislav , you need to write expression manually in tmap.