How to link these tables?

[Ferdie]

I'm trying to link the tables Hotels (30 records) to Rooms (5713 rows). Obviously HotelID is not the right to link these two together. How do you think I should proceed?

A reservation (right table) is supposed to be linked to a certain room in a hotel..

Please let me know. I'm new to QlikSense!

Thanks

[NitinK7 · Accepted solution]

Hi Ferdie,

try to use

left or right join between rooms and hotels table depend on your data.

Regards,

Nitin.