4 Replies Latest reply on Feb 10, 2012 1:11 AM by abrahammeir

Can't link two fields

abrahammeir Feb 9, 2012 7:58 AM

Hi, I am trying to use two data sources in one worksheet. I click on Data->Edit Relationships and then create a custom relationship linking the two data sets with one field (Hotel ID).

I know that a link icon should appear, but it doesn't.

What could be the problem here?

Thanks!

1. Re: Can't link two fields

Tim Latendress Feb 9, 2012 8:24 AM (in response to abrahammeir)

Abraham,

You will need to use the Hotel ID field somewhere in the viz to "activate" the relationship.Relating disparate data sources functions differently from a typical Join operation. Hope that helps.
Like Show 0 Likes(0)

Actions
2. Re: Can't link two fields

abrahammeir Feb 9, 2012 8:29 AM (in response to Tim Latendress)

Thanks Tim,

How can I use it without really changing the view?

I have one data set with hotel details, and a second one with reservation details. Linking field is hotel ID.

I want to show revenue by hotel type (revenue comes from reservations, hotel type comes from hotel details). But I don't want to break it down by Hotel ID. Is this possible?

Thanks
Like Show 0 Likes(0)

Actions
3. Re: Can't link two fields

Shawn Wallwork Feb 9, 2012 11:45 AM (in response to abrahammeir)

Abraham, Try putting it on the level of detail shelf.

--Shawn
Like Show 0 Likes(0)

Actions
4. Re: Can't link two fields

abrahammeir Feb 10, 2012 1:11 AM (in response to Shawn Wallwork)

Thanks Shawn. I did it but now I get overlapping cells, check out the screenshot
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Can't link two fields

1. Re: Can't link two fields

2. Re: Can't link two fields

3. Re: Can't link two fields

4. Re: Can't link two fields

Actions

More Like This