[resolved] tMap Expression Builder

Highlighted
Four Stars

[resolved] tMap Expression Builder

my question is when I use an expression in the tMap component and write a statement to compare column 1 to column 2 and then column 2 to column 3 I get the correct results when using test! mode. 
   
but when I use a test file (excel_input) > (tMap) > (Excel_output) I return results as all false in the new column 4 created (AUDIT) to audit columns 1, 2, & 3. Am I missing something?
(boolean) (row1.TRAN_SUBMITTED_BY == (row1.TRAN_ASSIGNED_TO)||
row1.TRAN_ASSIGNED_TO == (row1.TRAN_APPROVED_BY)) 
 

I should return 2 true values shouldn't I? 

after i return either true or false i would then continue my job to the tfilter component for rejects "true"

Thank you,
Paul
Community Manager

Re: [resolved] tMap Expression Builder

Hi 
To compare two string in Java, the expression is:
row1.TRAN_SUBMITTED_BY .equals(row1.TRAN_ASSIGNED_TO)
----------------------------------------------------------
Talend | Data Agility for Modern Business
Four Stars

Re: [resolved] tMap Expression Builder

I overlooked that entirely... works perfectly, Thank you for your support!

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

Introduction to Talend Open Studio for Data Quality

Find out about Talend Open Studio for Data Quality

Watch Now

Enabling Data Governance

Learn how to enable Data Governance

Watch Now

The Definitive Guide to Government Data Quality

Take a peek at the definitive guide to Government Data Quality

Read