TMAP Express math with mulitple columns

[Anonymous]

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.

[DataTeam1 · Accepted solution]

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