Data from another table filters out empty fields (should be visible)

[Matt78]

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. Problem is that if some of the open sales orders don't have shipment number yet, those orders will be filtered out if I connect these 2 tables.

I should have all sales orders visible and if they don't have a shipment number, then this field should be empty.

For example order 46225 doesn't have a shipment number but as seen in the last pic, it will be filtered out and only orders with shipment number is visible. I should have 46225 also here but with empty shipment field.

 

BR

Matt

[JoeBarry]

What is the relationship between the two tables? I will presum that the Sales orders has a Unique No_? If it does create a one to many relationship from the No_ column in Sales Orders and the Order.OrderNumber column in Warehouse Deliveries.  This should solve the issue

[Matt78]

Sales orders has a unique numbers, yes. These have relationship to Sales Lines so I can get articles each order contains. Sales Lines have relationship to Shipments, where I can get shipment numbers.

Sorry, I wasn't clear enough in my original post. I said 2 tables but there is 3 actually.

Sales Order Header:

order 46225

Sales Lines

order 46225

article 1

article 2

article 3

Shipments

order 46225 shipment SH123345

article 1

article 2

article 3

[JoeBarry]

Then the Sales Order Header should have a one to many relationship to both Sales Lines and Shipments on the Order ID column

[Matt78]

I did that but for some reason when I add Shipments in the matrox it gives error it cannot determine relationships between the fields.

[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

[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]

Hi @Matt78 

Turn on this 

Thanks

Joe

If this post helps, then please Accept it as the solution

[Matt78]

Thank you for the swift reply.

It partly works but it will empty article numbers also. I think the issue comes because article numbers come from sales header and shipments are connected to sales lines.

BR

Matt