Forum Discussion
Joining does not work properly
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
Hello,
I found what wrong with it. Yes, it has duplicates, I think I have to create a sub table. I am not sure how to achieve that. I put another detail post with example. You can see on this below link. Again, thank you so much your time and help. I appreciate it.