Skip to main content
Michael Eddie 님이 #Tableau Desktop & Web Authoring에 질문했습니다

Dear Tableau Community,

 

I have a datasource which records incidents attended by a helicopter medical service. I am having an issue with relating tables in Tableau. I have created some sample data and a packaged workbook to illustrate the issue.

 

Broadly speaking an incident is created each time the team attend a patient. More than one team may be on at once, but they may both attend the patient. Separate records therefore exist for each incident. The patient is however created only once, and may therefore belong to two or more incidents. This is handled using return separated values within the datasource.

 

This works find in our filemaker database, however when I add the data to Tableau it returns Null values for the downstream table. To illustrate this I have created a simple two table file. One patient belongs to two incidents (incidents 2 and 4). The incident data displays correctly, but any data from the patient table returns a null value. Is there a better way to configure this relationship to prevent this from happening?

 

Kind Regards,

 

Mike

 

(All data is fictional and does not relate to real patients or incidents)

답변 1개
  1. 2021년 10월 21일 오후 2:23

    Hi Mike,

    If you're attempting to get to the below view, you'll need to restructure the data for Patients:

    Hi Mike,If you're attempting to get to the below view, you'll need to restructure the data for Patients:From this...To this...From this...

    Screen Shot 2021-10-21 at 7.22.38 AMTo this...

    Screen Shot 2021-10-21 at 7.22.48 AMBest, Don