Null values

Highlighted
Six Stars

Null values

Hi. 

 

I've a problem with union data in tMap component, 'cause one of the output data has black values in some rows, problem with this, row I use as key is the row with black values in the other side each row in data has every value, when I run job, message is:

 

 Exception in component tMap_15 (Interceramic)
java.lang.NullPointerException
at local_project.interceramic_0_1.Interceramic.tFileInputExcel_5Process(Interceramic.java:24184)
at local_project.interceramic_0_1.Interceramic.runJobInTOS(Interceramic.java:1789)
at local_project.interceramic_0_1.Interceramic.main(Interceramic.java:1638)

 

I hope your help to resolve this situation.

 

Regards.

Employee

Re: Null values

Hi,

 

   You are getting the Null pointer excpetion in tMp. Could you please share the overall job flow and the screen shot of the tMap so that we will get more idea about what you are trying to achieve?

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved :-)

Six Stars

Re: Null values

Hi, Nikhil Thampi

 

Of Course

 

Job.jpg is the image where show the connection to join data

tMap.jpg is the connection I have with the tUnited and how I connect both of them by "No_Cntr_" and "No_Contenedor", "No_Cntr_" has black values

Salida.jpg shows one example that how data is, the red line shows column "No_Cntr_" and the rows are empty.

 

Regards

 

Employee

Re: Null values

Hi,

 

   I dont think that is the reason for null pointer exception. Are you using any functions or expressions in the tMap_15 (Interceramic)?

 

   If you are using any Java function like sub string, equals etc. for a column containing null value, it will throw this error.

 

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved :-)

Six Stars

Re: Null values

Hi.

 

According to your message, I don't use any function or expressions in tMap_15, expressions I used in tMap before to standardize each column but in tMap_15 don't; tMap_15 I'm ussing only to join both tUnite_1 (row 28) and tUnite_5 (row 44)

 

To answerer the second point, the column named "No_Cntr_" doesn't ussing any expression or function 'cause is a unique value and the way we received data is the same and that column is the key to integrated all data in one DB.

 

Regards. 

Six Stars

Re: Null values

And I don't know if when I want to join tUnite_1 and tUnite_5 the black values to has the column "No_Cntr_" to the output tUnited_1 be the problem because it does not have any value in tUnique_5 to joined.

 

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

Put Massive Amounts of Data to Work

Learn how to make your data more available, reduce costs and cut your build time

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now