Join in tmpa and trim

Anonymous — Sat, 16 Nov 2024 13:54:41 GMT

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

Re: Join in tmpa and trim

Anonymous — Thu, 18 Jun 2009 07:33:55 GMT

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

Re: Join in tmpa and trim

Anonymous — Thu, 18 Jun 2009 07:47:26 GMT

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

Re: Join in tmpa and trim

Anonymous — Fri, 19 Jun 2009 04:50:03 GMT

Hello

java.lang.NullPointerException

row3.yourColumnName==null?null tringHandling.TRIM(ro31.yourColumnName)
Best regards
shong

topic Re: Join in tmpa and trim in Talend Studio

Join in tmpa and trim

Re: Join in tmpa and trim

Re: Join in tmpa and trim

Re: Join in tmpa and trim