Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@Mstislav , you need to write expression manually in tmap.