topic Default column values to blank in Talend Studio

Default column values to blank

Anonymous — Tue, 17 Apr 2018 21:41:17 GMT

Hi,

I want to default values for my column 'ProductCode' to blank i.e. no value in output file.

I edited the schema and put default " " for that member. Still the outfile populates value for that column based on the input file.

Re: Default column values to blank

Anonymous — Tue, 17 Apr 2018 22:58:24 GMT

OK, first " " is a space, it is not blank. "" is an empty string, it is not blank. NULL is what you want if you want it "blank i.e. no value". To do this, simply do not connect the column. If you want an empty string, assign "" to the value. You do not need to touch the "Default" value.

Re: Default column values to blank

manodwhb — Mon, 23 Apr 2018 12:27:11 GMT

@KanT,can you explain more? what exactly you want to populate?