Forum Discussion

crispybits77's avatar
crispybits77
Icon for Helper I rankHelper I
2 years ago
Solved

Limiting table visual to records in a single source

I have a table visual that draws from two different source data tables. For simplicity with an example the source tables look like this:   Source1: Emp ID Name Source2: EmpID Name of Pet ...
Need Help
  • hackcrr's avatar
    hackcrr
    2 years ago

    Hi, crispybits77 

    Thank you very much for your reply. I think you can try him. Additionally, you can create a relationship for two tables and put one of the ID columns into table visual to get a similar effect:

    I prefer to build relationships, which will optimize performance.

     

     

    Best Regards,

    hackcrr

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

crispybits77's avatar
crispybits77
Icon for Helper I rankHelper I
2 years ago

Thanks hackcrr 

Is there much performance penalty for this? In the real world scenario my tables both have 10,000s of rows.

hackcrr's avatar
hackcrr
Icon for Memorable Member rankMemorable Member
2 years ago

Hi, crispybits77 

Thank you very much for your reply. I think you can try him. Additionally, you can create a relationship for two tables and put one of the ID columns into table visual to get a similar effect:

I prefer to build relationships, which will optimize performance.

 

 

Best Regards,

hackcrr

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.