Forum Discussion

Wael03's avatar
Wael03
Helper I
3 years ago

Lookup

Hello,

 

I have a dataset with id that corresponds to bank :

 

I made a connection to an other dataset with id and their Group to connect the bank to their group : 

 

Here is the connection :

 

 

So now here is my problem. In this dataset some bank are not related to any group so the connection is blank but what I want to do is whenever the connection is blank I want to put the name of the bank directly not the group. Is it possible to do so ?

 

Thank you ! 

 

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Wael03 , if you create a join any blank on many sides will be shown as blank.

    You need to transform data to have values for blank and that value should be available in the master table to join

     

    We use add a row in master id = -1 and Name = NA and use populate -1 in blank in fact table