topic Re: TMAP Express math with mulitple columns in Talend Studio

TMAP Express math with mulitple columns

Anonymous — Tue, 05 Mar 2019 22:32:16 GMT

Hello! Im trying to use TMAP to do some calculations and then Concatenate the result to another column. So for example. If you look attached, I want to add MinW with AddrMin if AddrMin != AddrMax. It says "The method add(Float) is undefined for the type Float". So how can I subtract, sum, divid and Add two different columns together and Concat the result to another column.

Re: TMAP Express math with mulitple columns

DataTeam1 — Tue, 05 Mar 2019 23:30:11 GMT

I don't know if you want to sum or to concat.

Sum means 1 + 1 = 2

Concat means "1" + "1" = "11"

I suppose you want to sum so try this

COUNT_FIELDS.AddrMin = COUNT_FIELDS.AddrMax ? COUNT_FIELDS.AddrMax : COUNT_FIELDS.MinW + COUNT_FIELDS.AddrMin