topic For input string: "null" in Talend Studio

For input string: "null"

dee5 — Sat, 16 Nov 2024 11:43:36 GMT

Hi
I have a Talend job that works seemingly perfectly except for this red text:
For input string: "null"
For input string: "null"
For input string: "null"
For input string: "null"
For input string: "null"
For input string: "null"
For input string: "null"
For input string: "null"
For input string: "null" etc
I have taken a CSV file and filtered it before placing the data in a table. How do I get rid of this red text? Or it is ok?

Re: For input string: "null"

Anonymous — Fri, 07 Mar 2014 06:38:13 GMT

Hi,
How did you set your input schema? The "null" string must be rejected by tfileinputxxx component according to your schema setting. You can set your schema data type as "String" without checking.
Best regards
Sabrina

Re: For input string: "null"

dee5 — Fri, 07 Mar 2014 06:57:04 GMT

Hi Sabrina,
I have no idea how I set my input schema... where do I find that out? How do I reject the null string? And how do I set the data type without checking?
I'm obviously very new to all this...

Re: For input string: "null"

dee5 — Fri, 07 Mar 2014 07:15:05 GMT

I realised I can make it not null in the schema setting. Is that was you meant? So I did that but I still have the same problem...

Re: For input string: "null"

Anonymous — Fri, 07 Mar 2014 07:18:29 GMT

Hi,
To make it clear, I have designed a demo job for you.
I have input file:
id;name
null;elise
2;shong
3;sabrina
There is "null" string in it. You will get the info "For input string: "null", if you set the id column as "Int"(see my pic1, pic 2 )
You can set your schema data type as "String" without checking( it is not rejected by tfileinputxxx component, see my pic 3,4)
Best regards
Sabrina

Re: For input string: "null"

dee5 — Fri, 07 Mar 2014 07:28:18 GMT

Awesome. I appreciate that effort to help me.
So I just change my int to String?
I did that and that issue is gone but then i get this:
Incorrect integer value: 'null' for column 'ID' at row 10

Re: For input string: "null"

dee5 — Fri, 07 Mar 2014 07:30:03 GMT

Oh... nevermind. I see in the file there isn't a number but rather the word "null"...

Re: For input string: "null"

Anonymous — Fri, 07 Mar 2014 07:33:47 GMT

Hi,
Talend offers a rich set of online and instructor-led training courses to speed your ramp-up time, deliver projects faster, and maximize your Talend investment.
You can have a look at it http://www.talend.com/services/training.
Feel free post your issue on forum.
Best regards
Sabrina