topic Re: How to set default integer value for a column in Talend Studio

How to set default integer value for a column

Anonymous — Thu, 19 Apr 2018 03:47:26 GMT

Hi,

I want to set the default value of the certain column to 1. Should I make the change in the input file by defining the default value as "1".

I tried couple of combinations by making it as 1, or "1", change the field type to String. But nothing works.

How do I set value to 1..? Thanks!

Anonymous — Thu, 19 Apr 2018 05:01:37 GMT

Hi
Why you need to change the default value? Normally, the default value only works when creating tables on DB output component.

Regards
Shong

Anonymous — Thu, 19 Apr 2018 05:03:36 GMT

Hi Shong,

It's a business scenario where they want one of the columns to have default value set to 1.

Is there no way we can do it in Talend..? Thanks!

Anonymous — Thu, 19 Apr 2018 05:14:38 GMT

Can't you set it to 1 manually? Or you want to read this value from somewhere and set it?

manodwhb — Thu, 19 Apr 2018 05:43:28 GMT

Can you try in tmap expression like

row1.fieldname== null ? 1 : row1.fieldnam

manodwhb — Thu, 19 Apr 2018 05:54:28 GMT

@KanT,i have tested default value for integer coumn working fine,i believe your file might have spaces,please check.

i am attacing input file and screenshoots.

Anonymous — Thu, 19 Apr 2018 19:08:25 GMT

Hi,

So this column is a new column and doesn't exist in the input file but I added it in output file.

so, I add the column in output of tmap. and in Tmap try to set it default value to 1. It doesn't work.

can I not set default values in Tmap?

vboppudi — Thu, 19 Apr 2018 19:32:36 GMT

Hi,

If you create output column in tMap then use default value in expression.

Regards,

manodwhb — Tue, 22 May 2018 08:50:13 GMT

@KanT,you cannot set the default value for the column which not having input in tmap,

since you see harcode the value under Expression of Output section.