Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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.
you have to check "Use advanced mode" checkbox, then a code textbox will appear
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.
maybe they don't have the same structure, you have to investigate on this