Showing Customer that does not have records in customer Master table

[AH]

Hi,

I have a scenario like this,

We have shipments data for Customers that doesnot have a customer number in our Customer Master table. So what happening is, the shipping company put a Dummy Customer number if they dont have any customer number for that customer.

So, Now my problem is, inmy data model, CustomerID is the key to connect customer Master and shipment table and other tables. Since, Dummy Customer ID/ Number does not resides in Customer Master and it only resides in Shipment table its not showing in the dashboard table after I reload the data model.

Is there any way i can show the dummy customer details in the Dashboard table?

Any Suggestion please!

Thanks,

Ahmed

[robert_mika]

You can use Exist in load to get the "real" or Dummy Customer.

Could you post sample of your data?

[shambhub]

Ahmed,

This is the case that you are making Customer master table as fact table I mean base table, hence you are not getting dummy customer code in the dashboard. But to overcome this problem you can try like this

ShipmentData:

Load  Cust_ID, Ship_Date, Ship_Qty

from Shipment_table

Left join (ShipmentData) // Here you can you use Left keep also depending upon on the reqmnt

Customer_Master:

Cust_ID, Cust_Name, Cust_Address

From Customer_Master_Table;

Please let me for any clarification.

[Anonymous]

The right thing to do is to add a generic (dummy) customer into the master table.

[ankitaag]

Can you provide a small data set or some data to get the best solution

[Anonymous]

Something like this,

Customer_Master:

Load

Customer_ID,

//other fields

from customer master;

ShipmentTable:

Load

if(exists(Customer_ID,Shp_Cusomter_ID),Shp_Cusomter_ID,'Unassigned') as Customer_ID;

//other fields

[Anonymous]

i agree...this way, data is not lost.