Forum Discussion
Helper IVData Missing After Relationship Created
Hi all,
I am connecting several data sets together. Right now, I am trying to connect a table with the dimensions of all my products (height, weight, etc) to a table that has additional information about each product (department, additional metrics, colors, etc). When I load each dataset in, there is no problem - all the data shows up. But the moment I try to connect a relationship between the two tables, all the data from the second dataset (department, additional metrics, etc) goes away. I am connecting it on SKU and it is a One-Many relationship. The other tables I have connected (dates, Sales data, etc) are perfectly fine, it's just this one table.
Does anyone have any ideas for how to fix? I've tried changing the relationship, making it bidirectional, single direction, etc, and nothing is changing it.
1 Reply
- DataInsights
Super User
Does the product table with additional information have the same grain as the primary product table (one row per product)? If so, you can merge the two product tables in order to have a master product table. This will allow you to have a star schema (dimension tables with relationships to fact tables).
