Left Join - adding a value for unjoined rows

[nickmarlborough]

Hi, 

I have a table called [FULL SCOPE] and then am joining [IMPORTANT] to it which hold s fraction of the [FULL SCOPE] and there is a column called [Important] which is Y in the table [IMPORTANT].... 

ive done a left join - which means a large portion of [FULL SCOPE] will have no value in the column [Important] .... how can i have it so essentially if they didnt join....its 'N' in the column rather than appearing as null/empty in the table

Thanks 

[Bhushan_Mahajan]

@nickmarlborough First join the tables then do the transformation as per below,

if(isnull(important),'N',important) as New_Important.

[marcus_sommer]

You may use a mapping instead of a join because it provides the possibility to set a default-value for the non-matching. To transfer not only a single field you could string-concatenating n ones like:

F1 & '|' & F2 ...

and then wrapping the applymap() with a subfield() by the call to split the string again.