Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
nickmarlborough
Creator
Creator

Left Join - adding a value for unjoined rows

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 

Labels (1)
2 Replies
Bhushan_Mahajan
Creator II
Creator II

@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.