Data_Type converstion Error

[Talend_ent]

Hi all,

I'm trying to convert integer column to string getting "java. lang.NumberFormatException: For input string:"

my input integer column is as follows

1234

4467

4646

opt:

1234

4467

4646

I tried with Integer.toString(row1.emp_num) it throwing Number format exception.

Any suggestions would be helpful

Thanks and Regards,

Talend_ent.

[gjeremy1617088143]

couls you send some capture of the components , input flow ,input output schema of the component ?

cause I try with this in entry as string :

 1234

4467

4646

opt:

1234

4467

4646

and in output int nullable

it works

result :

1234

4467

4646

null

1234

4467

4646

[Talend_ent]

Hi @guenneguez jeremy please find the attachments regarding job design and respective component configuration.

[Talend_ent]

[Talend_ent]

[gjeremy1617088143]

Ok var1 is an int ,it doesn’t support null value, so set Integer instead of int in the schema of var1 and in the tmap output schema checked null for your int type of var1 field. it will transform it as Integer wich support null value.

Send me Love and Kudos