Default column values to blank

Six Stars

Default column values to blank

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.

 

11.png


Accepted Solutions
Sixteen Stars

Re: Default column values to blank

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.


All Replies
Sixteen Stars

Re: Default column values to blank

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.

Thirteen Stars

Re: Default column values to blank

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

 

Manohar B