Talend community forum / [resolved] tMap/ tFilterRow - NullPointer exception when reading Excel File

obelix · 2009-09-16 13:00:16

Tags: [CSV file, delimited file, deployment, development, error, error management, positional file, tos3.0.0]

Hi All,

I am using Talend Version: 3.0.2 Build id: r20205-20081119-1100. My problem is that I am getting a NullPointer exception when doing a filtered read from an Excel file into an MS SQL DB table. I have tried to use either tMap or tFilterRow and I still get the error on both. I have attached the flow and error details on the images. I dont generally get this problem and have a strong suspicion that this is specific to that file (empty row or cell perhaps) but I am not sure on how best to get round it.

Uploaded Images

Last edited by obelix (2009-09-16 13:04:04)

shong · 2009-09-17 05:39:46

Hello guy
You need deal with the null vlaue. eg:
row3.column1!=null&&row3.column2!=null&row3.column1.startsWith("HH")&&row3.column2.indexOf("**crash")==-1

Best regards

shfong

ishk · 2009-09-17 06:31:59

hi,
im new to talend open studio, i want to get the rejected inner join rows into excel file
please help me to solve this

Uploaded Images

Last edited by ishk (2009-09-17 06:35:04)

shong · 2009-09-17 07:39:52

Hello Ishk

Please see [Forum, topic 2202] Query from different databases, I give an example in that topic.

Best regards

shong

obelix · 2009-09-17 11:16:56

Thanks Shong that did the the trick.

ishk · 2009-09-21 09:14:56

thanx i did it

Announcement

Unanswered posts

#1 2009-09-16 13:00:16

[resolved] tMap/ tFilterRow - NullPointer exception when reading Excel File

#2 2009-09-17 05:39:46

Re: [resolved] tMap/ tFilterRow - NullPointer exception when reading Excel File

#3 2009-09-17 06:31:59

Re: [resolved] tMap/ tFilterRow - NullPointer exception when reading Excel File

#4 2009-09-17 07:39:52

Re: [resolved] tMap/ tFilterRow - NullPointer exception when reading Excel File

#5 2009-09-17 11:16:56

Re: [resolved] tMap/ tFilterRow - NullPointer exception when reading Excel File

#6 2009-09-21 09:14:56

Re: [resolved] tMap/ tFilterRow - NullPointer exception when reading Excel File

Board footer