Error in the second file of a tFileList

[EvoticTalend]

Hi everyone!

I have a subjob like this:

Im reading a directory with the tFileList element, and I read an Excel in the next element.

The problem is in the JavaFlex, I have this error:

When starts to read the second file (you can see that in "1 exec finished . 1 exec runing" at tFileList component i have this error of NULLPOINTEREXCEPTION. My java code is doing a transformation of a column.

Anyone maybe know how I can fix this? thanks!

[gjeremy1617088143]

Hi @Ivan R​ ,

it's seems you have a null value for Video_URL,

yo have to make your code null safe

you can also before your tJavaFlex add a tFilterRow and in advance filter:

input_row.Video_URL != null

to filter null value before executing the code of tjavaflex

Send me love and kudos

[EvoticTalend]

Thank you for the different solution jgeremy. How can i put this code in an advance filter in tFilterRow? I haven't used that component and I don't see anything to code in tFilterRow.

[gjeremy1617088143]

you have to check "Use advanced mode" checkbox, then a code textbox will appear

[EvoticTalend]

Thank You very much gjeremy. I found that with this flow, the second file in the tFileList is ALL NULL, because when I put the tFilterrow, the result is 0 rows. Is not correct because the second Excel is all filled in.

Maybe you know why is this ocurring? THANK YOU.

[gjeremy1617088143]

maybe they don't have the same structure, you have to investigate on this