Value in linked table separates one row in table into two rows

[DataShark]

I have two data tables: Customers and Hometowns.

In Qlik Sense, I have a table where I represent this information.

When I have use only Customers-data with fields CustomerID, Name, etc, I can see only one row per CustomerID.

Next, I'll load the Hometowns data, that is linked using key CustomerID. Now all the Customers that have values in Hometowns-data are seen as two separate entries in the table. The other one has '-'-sign indicating a null value and the other one has the city.

What I would like to intuitively do, is to force these rows to merge, but I believe this approach is not used in Qlik Sense.

Hence I would be interested in other solutions to have them shown as one row.

[DataShark · Accepted solution]

Found the problem, the table Customers was created by concatenating two tables, and the key CustomerID was not found in the other, making it NULL thus creating two rows.