Automate

 View Only
  • 1.  Query - One field not equal to another

    Posted 05-15-2020 14:08
    Hello! 

    I am trying to write a query to extract customer master records where the region does not match the transportation zone. I have poked around with the criteria, but nothing is jumping out at me. Is this possible? If so, could you please steer me on the right track?

    Thank you!


  • 2.  RE: Query - One field not equal to another

    Employee
    Posted 05-21-2020 10:34
    Hi Megan

    As you have found, it is not possible to do in Query today.  Please open a Support ticket to submit a product improvement.  I think it would be a great addition.  :) 

    Best Regards,
    Sigrid

    ------------------------------
    Sigrid Kok
    PSE | Winshuttle NA
    ------------------------------



  • 3.  RE: Query - One field not equal to another

    Posted 05-21-2020 10:47
    Thanks, Sigrid! I will do that!

    ------------------------------
    Megan O'Leary | Information Systems/Information Technology Technology Professional
    Bose Corporation | +1.508.766.8736
    ------------------------------