DSXchange

Hi,

I am trying to Join two datasets by using Join stage and performing the Full outer Join.

So I am getting the output in several fields for several unmathed rows with some defalult values .

Like for date type i am getting 0001-01-01 and for Intger type I am getting Value 0

Instead of getting this defalut values for un-matched records I need to get either Null or Blank.

I searched in manuals and forum but not found any....

Can any body suggest where can i orverwrite the defalut values?

Regds

You can do one of two things. To make columns null when there is no match you need to set the column to nullable. To assign default values you need to go to the columns tab and double-click on the box with the column number to open the meta data editor.

michaeld wrote:You can do one of two things. To make columns null when there is no match you need to set the column to nullable. To assign default values you need to go to the columns tab and double-click on the box with the column number to open the meta data editor.

Hi When I made it is Nullable at the Joiner stage instead of giving the Null values at the fields, The defalut value contained records are filtering.

I made to nullable for a particlulor field date and ran but the records are filtering

Where exactly i need to set the Nullable to 'Yes'

Thanks for the response.


Regds

irajasekharhexa wrote:

michaeld wrote:You can do one of two things. To make columns null when there is no match you need to set the column to nullable. To assign default values you need to go to the columns tab and double-click on the box with the column number to open the meta data editor.

Hi When I made it is Nullable at the Joiner stage instead of giving the Null values at the fields, The defalut value contained records are filtering.

I made to nullable for a particlulor field date and ran but the records are filtering

Where exactly i need to set the Nullable to 'Yes'

Thanks for the response.


Regds

Hi Mike,

I was not made the nullbale to 'Yes' Propery. Now It's working fine.

Thanks Lot.

Regds
Rajasekhar

Time to mark the thread as Resolved.