Mapping based on field value

Anonymous — Sat, 16 Nov 2024 02:18:50 GMT

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

Re: Mapping based on field value

manodwhb — Wed, 27 May 2020 15:40:10 GMT

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

topic Re: Mapping based on field value in Talend Studio

Mapping based on field value

Re: Mapping based on field value