Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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