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