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

1 ACCEPTED SOLUTION

Accepted Solutions
Fifteen 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.

Rilhia Solutions
2 REPLIES
Fifteen 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.

Rilhia Solutions
Twelve Stars

Re: Default column values to blank

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

 

Manohar B