Forum Discussion

Applicable88's avatar
Applicable88
Icon for Impactful Individual rankImpactful Individual
4 years ago
Solved

Looking for not equal rows

Hello, I have two tables from the same source. The tables consist of machine data, for example there are OrderID's and the Datetime when the machine finished packing it. Unfortunately the leading pr...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    Are you using the Composite key to create the relationship? If so, try making it a whole number instead (101052021, 102052021...)

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
4 years ago

Are you using the Composite key to create the relationship? If so, try making it a whole number instead (101052021, 102052021...)

Applicable88's avatar
Applicable88
Icon for Impactful Individual rankImpactful Individual
4 years ago

Very good idea. Thanks PaulDBrown . After replacing all punctuation in the date with space and then combined the column with the order id I got a distinct primary key as a whole number to work with.