I cannot link two tables even though there is a relationship

[bahar1]

Hi all!

I have two reports one called Shipped Items and the other TWO report. I am both linking them to a sheet called Orders(which I created by appending the two queries and removing duplicates) to the order numbers. But when I want to use fields from the two reports, it gives an error that there is no connection between the fields. I have no idea what I am missing..

[BalaVenuGopal]

Hi @bahar1 ,

Check data type of order number from both the tables (datatype of order number in all the joining tables must be same.

 hope this will resolve this issue .

Please mark as solution if this works for you

[bahar1]

Hi Thank you very much I checked and they were not the same. However even after transforming everything to number, the same error continues..