Forum Discussion
Joining does not work properly
If you look at your int table, it has only one row for SKU BPCBDP000176 with inv. quantity 79. if you want break down by store then you need to store invt. quantity by store in this table and that is what is missing.
I'm not sure your sure in your table below where did you get the break down of invt. quantity by store and sku.
Thank you for the respond. That might be the reason, but when I add store to the Int table I cannot join with Sales table due duplicate values. Do you creating another table for sku and join everything to sku will work for that?
Thank you so much
create a calculate column for key by concatenating both store number + sku in both Int and sales table and then set relation on that new calculated column, it will give you what you need.
Hello,
I am so sorry to keep bothering you. I did what exactly you said, and It gives me the same error, please see the below pictures. Do I need create another table or what will be the best solutions?
Thank you so much
well as message say invt table has duplicate values or there is null value. check you inventory table and value in PK