Default column values to blank

[Anonymous]

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.

[Anonymous · Accepted solution]

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.

[manodwhb]

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