topic Re: Transform incoming data from toracleinput and output into file in Talend Studio

Transform incoming data from toracleinput and output into file

Anonymous — Wed, 08 Aug 2018 14:58:07 GMT

Hi ,

i want to edit the data coming from toracleinput like substring in tmap/ tjavarow and output to file.

toracleinput -> tmap -> tfileoutputdelimeted

i am currently getting null pointer exception.

But this works if i do it in another subjob storing the values first in a file and then transforming the data like below:

toracleinput -> tfile

tfileinput -> tmap -> tfileoutput

But i want to directly do it in single step as its consuming time.

Thanks in Adv,

Hachi

Re: Transform incoming data from toracleinput and output into file

Jesperrekuh — Wed, 08 Aug 2018 16:02:54 GMT

In tmap you could write this code :

row1.name == null ? null : row1.name.substring(1,3)

The nullpointer exception is raised because the function cant handle null values, if you would put an empty string like "" its possible and thats the reason why first storing it into a file works...
Make sure your output table can handle null values... because an empty string "" isnt the same as "null"