Lookup

[Wael03]

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 ! 

[amitchandak]

@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