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

Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
bmac27
Contributor
Contributor

Joining a one-to-many relationship

 

I have this table of products and their associated representative

bmac27_0-1695831285496.png

I also have a fact table with the fields Order, Date, Product, and Sales.

I want to find a way to join the reps associated with each product in the fact table--however I do not know what the best practice is for this since there are multiple reps assigned to a single product.

 

Labels (4)
1 Reply
bmac27
Contributor
Contributor
Author

bmac27_0-1695831583890.png

Here's an example of what a row in the fact table looks like