topic Error in the second file of a tFileList in Talend Studio

Error in the second file of a tFileList

EvoticTalend — Fri, 15 Nov 2024 23:54:52 GMT

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!

Re: Error in the second file of a tFileList

gjeremy1617088143 — Wed, 28 Jul 2021 06:45:24 GMT

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

Re: Error in the second file of a tFileList

EvoticTalend — Wed, 28 Jul 2021 07:09:40 GMT

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.

Re: Error in the second file of a tFileList

gjeremy1617088143 — Wed, 28 Jul 2021 07:17:59 GMT

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

Re: Error in the second file of a tFileList

EvoticTalend — Wed, 28 Jul 2021 08:41:15 GMT

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.

Re: Error in the second file of a tFileList

gjeremy1617088143 — Wed, 28 Jul 2021 08:51:14 GMT

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