TMAP Express math with mulitple columns

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
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


All Replies
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

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download