Forum Discussion
Matt78
Helper II
Helper IIData from another table filters out empty fields (should be visible)
Hello, I have 2 data sources, other one is sales order list and other one is warehouse shipments with shipment numbers. What I would like to have is to get shipment numbers to my sales order list...
JoeBarry
Solution Sage
Solution SageThen the Sales Order Header should have a one to many relationship to both Sales Lines and Shipments on the Order ID column
Matt78Helper II
Helper III did that but for some reason when I add Shipments in the matrox it gives error it cannot determine relationships between the fields.
- JoeBarry
Can you share a screen shot of the top rows of each table. I need to see what format they have
- Matt78
Sales Order Header
Sales Order Lines
Shipments
- JoeBarry
Add to the Matrix, the No_ from Sales Order 1st (This is the shared dimension). Then add the columns you need from the Sales Line Items, then the Shipments.
- Matt78
Relationships should be ok but it still gives error when I add shipments to the matrix