Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Ferdie
Partner - Contributor II
Partner - Contributor II

How to link these tables?

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..

 

Knipsel.PNG

 

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

Thanks

Labels (1)
1 Solution

Accepted Solutions
NitinK7
Specialist
Specialist

Hi Ferdie,

try to use

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

Regards,

Nitin.

 

View solution in original post

1 Reply
NitinK7
Specialist
Specialist

Hi Ferdie,

try to use

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

Regards,

Nitin.