Forum Discussion

Philip_L's avatar
Philip_L
Frequent Visitor
4 years ago
Solved

Relationship without filtering

I have two datasets simular to below. I need to put into a single table visual. 

What I want is this...

but what I get is this...

I've tried a 1:* and *:* and I get the same results.

What am I doing wrong? Any help would be greatly apprecaited.

Need Help
  • TheoC's avatar
    TheoC
    4 years ago

    Hi Philip_L 

     

    Here is what you are wanting mate. I just posted a fresh reply so that it cleans up the comments, etc.

     

     

5 Replies

  • TheoC's avatar
    TheoC
    Community Champion
    4 years ago

    Hi Philip_L 

     

    Ensure that the Key from Dataset 1 is the ONE and the Key from Dataset 2 is the MANY.  Have a SINGLE direction relationship from Dataset 1 to Dataset 2.

     

    Use the Dataset 1 Key in Column 1. Use Dataset 1 Name in Column 2. Use Dataset 2 in Column 3.

     

    Also, ensure that you do not have any filters on for State being blank.  Check your visual and the filter pane and make sure that State does not have any filters 🙂

     

    • Philip_L's avatar
      Philip_L
      Frequent Visitor
      4 years ago

      Thanks for the response. Unfortunately thats how I have it setup already. I am still getting the same filtered results which is why I am not sure whats happening.

      • TheoC's avatar
        TheoC
        Community Champion
        4 years ago

        Philip_L my apologies!  I misread your output, all you need to do is press "Show Items With No Data" on the Key / State / Name fields ğŸ™‚

         

         

  • TheoC's avatar
    TheoC
    Community Champion
    4 years ago

    Hi Philip_L 

     

    Here is what you are wanting mate. I just posted a fresh reply so that it cleans up the comments, etc.