link two dimensions with conditions either at load script or at UI by creating a new dimensions

[coloful_architect]

Hi guys,

I am trying to create a dimensions from two other dimensions by a key. The tricky part is that if the key does not find the associated value , I want to show the original data rather than null. Here is an example to better illustrate my case.

Table 1:

ID , User Name, 

Table 2:

ID,  Legal Name

New field/dimension:

Final Name( if ID does not find Legal Name, use User Name)

so the new field/dimension would be Final Name. and I can NOT find Legal Name, I wanna show User Name instead. 

btw, since table 1 is the major table for my dataset, I am using left join to link Table 2. 

is there a smart way to build that Final Name? 

Thanks 

[canerkan]

Hi Coloful_architect,

you could use a mapping load in your load script like this:

mapRealName:

Mapping Load

ID, Legal Name

From ...

Table1:

Load 

ID,

User Name,

ApplyMap('mapRealName', ID, User Name) as FinalName

From ....

Hope this helps,

Can