topic Re: How to populate a column as blank in outputfile in Talend Studio

How to populate a column as blank in outputfile

Anonymous — Tue, 17 Apr 2018 00:14:44 GMT

Hi,

I have column called 'description' but I want this column to be populated as blank in the output file. How should I do it..?

Re: How to populate a column as blank in outputfile

Anonymous — Wed, 18 Apr 2018 07:26:39 GMT

Hello,

You can try to replace your column with"" by using replaceAll(old char, new char) in tMap.

Let us know if it works for you.

Best regards

Sabrina

Re: How to populate a column as blank in outputfile

manodwhb — Wed, 18 Apr 2018 07:27:22 GMT

@KanT,if you do not give Expression of Out section in tmap,will populate as blank.

please find the bleow screenshoot.

Re: How to populate a column as blank in outputfile

Anonymous — Wed, 18 Apr 2018 17:08:39 GMT

Hi Manodwhb,

One more thing, if 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..?

Re: How to populate a column as blank in outputfile

manodwhb — Thu, 19 Apr 2018 05:00:42 GMT

@KanT,you can use below link to set the default values in tfileinputdelimited.

https://help.talend.com/reader/mhqCkTBnin7IXmJBUJoocQ/~H7aem4LpI~B45e74SJN1w

Re: How to populate a column as blank in outputfile

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

Thanks for the link. I did look this link before. It talks about setting default values for string. But if u want to default integer values, it doesn't work this way.

Re: How to populate a column as blank in outputfile

manodwhb — Thu, 19 Apr 2018 05:13:50 GMT

Otherway you can try in tmap that expression somting like

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