• Index
  •  » Usage, Operation
  •  » [resolved] tMap/ tFilterRow - NullPointer exception when reading Excel File

Post a reply

Write your message and submit

Options

Click in the dark area of the image to send your post.

Go back

Topic review (newest first)

ishk
2009-09-21 09:14:56

thanx i did it

obelix
2009-09-17 11:16:56

Thanks Shong that did the the trick.

shong
2009-09-17 07:39:52

Hello  Ishk

Please see topic:2202, I give an example in that topic.

Best regards

         shong

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

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

obelix
2009-09-16 13:00:16

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.

Board footer

Powered by FluxBB