Join in tmpa and trim

One Star

Join in tmpa and trim

Hello
I have a tmap component to join a table (main) and an Excel file (lookup).
When I run my job I get the following error:
Warning: Object record is not associated with a drawing record - ignoring
The column in the table and in the excel file is a string of 15 characters
I thing the problem is due to spaces in the excel file.
Is it possible to add a StringHandling.TRIM function when you create the join between the main table and the excel file?
In other words, how to remove spaces in the column of excel file ?
Thanks for your help
Didier
Community Manager

Re: Join in tmpa and trim

Hello
Add a tJavaRow or another tMap to trim the space before join.
eg:
tMysqlInput-->tJavaRow(output_row.name=StringHandling.TRIM(input_row.name))-->tMap(do your join)
Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Join in tmpa and trim

I have added a tmap
and I have still the same error and a new one:
tarting job ArticlesUCv3 at 08:43 18/06/2009.
connecting to socket on port 3719
connected
Debug: format string is 000000
Debug: format string is 00
Debug: format string is 000
Warning: TBD on sheet "item warehouse" not supported - omitting
Warning: Object record is not associated with a drawing record - ignoring
Warning: Object record is not associated with a drawing record - ignoring
Warning: Object record is not associated with a drawing record - ignoring
Warning: Object record is not associated with a drawing record - ignoring
Warning: Object record is not associated with a drawing record - ignoring
Warning: Object record is not associated with a drawing record - ignoring
Warning: Object record is not associated with a drawing record - ignoring
Warning: Object record is not associated with a drawing record - ignoring
Warning: Object record is not associated with a drawing record - ignoring
Warning: Object record is not associated with a drawing record - ignoring
Warning: Object record is not associated with a drawing record - ignoring
Warning: Object record is not associated with a drawing record - ignoring
Warning: Object record is not associated with a drawing record - ignoring
Warning: Object record is not associated with a drawing record - ignoring
Warning: Object record is not associated with a drawing record - ignoring
Warning: Object record is not associated with a drawing record - ignoring
Warning: Object record is not associated with a drawing record - ignoring
Warning: Object record is not associated with a drawing record - ignoring
Warning: Object record is not associated with a drawing record - ignoring
Exception in component tMap_2
java.lang.NullPointerException
at routines.StringHandling.TRIM(StringHandling.java:286)
at projet_m3.articlesucv3_0_1.ArticlesUCv3.tFileInputExcel_1Process(ArticlesUCv3.java:15323)
at projet_m3.articlesucv3_0_1.ArticlesUCv3.tAS400Input_3Process(ArticlesUCv3.java:4901)
at projet_m3.articlesucv3_0_1.ArticlesUCv3.runJobInTOS(ArticlesUCv3.java:15783)
at projet_m3.articlesucv3_0_1.ArticlesUCv3.main(ArticlesUCv3.java:15689)
disconnected
Job ArticlesUCv3 ended at 08:43 18/06/2009.
What is the best solution to debug it?
Thanks
Didier
Community Manager

Re: Join in tmpa and trim

Hello
java.lang.NullPointerException

row3.yourColumnName==null?nullSmiley FrustratedtringHandling.TRIM(ro31.yourColumnName)
Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business

Calling Talend Open Studio Users

The first 100 community members completing the Open Studio survey win a $10 gift voucher.

Start the survey

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

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

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