TMAP Express math with mulitple columns

Highlighted
Five Stars

TMAP Express math with mulitple columns

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.

 

 


Accepted Solutions
Highlighted
Seven Stars

Re: TMAP Express math with mulitple columns

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

DataTeam.pl

View solution in original post


All Replies
Highlighted
Seven Stars

Re: TMAP Express math with mulitple columns

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

DataTeam.pl

View solution in original post

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog

Downloads and Trials

Test drive Talend's enterprise products.

Downloads