Automate

 View Only

  • 1.  Specifying Criteria during Query

    Posted 08-24-2022 01:52
    Hi,

    I am running into an issue with queries where the information is not specific to all my inputs, 
    For example, say I had material and plant as the two criteria, and I wanted to pull relevant information. 
    Material 655555 in plant 0002  and material 788888 in plant 0005 

    I want only two lines, one for each material in that specific plant but if both materials exist in the other plant as well I would get 4 lines. (Each material in both plants).
    How can I specify to only pull material 1 in plant 0002, and material 2 in plant 0005, without any crossover of the values. 

    Your help is greatly appreciated :) 

    - Michael, 416-624-0306

    ------------------------------
    Michael Codreanu | Specialist, Supply Chain Master Data
    Apotex Inc | 4166240306
    ------------------------------


  • 2.  RE: Specifying Criteria during Query

    Posted 08-25-2022 01:43
    I don't think it's possible to rule out the crossover results within the query. If it is, I'd like to hear about it too.

    I believe that previously this issue has been solved using a separate Excel formula. It concatenates the given criteria and extracted results and then compares them, probably using vlookup.

    So for example 
    Criteria
    655555&0002
    788888&0005

    Results
    655555&0002, formula shows as desired
    655555&0005, formula shows as not desired
    788888&0002, formula shows as not desired
    788888&0005, formula shows as desired

    Then the formula column can be filtered using these results.


    ------------------------------
    --
    ------------------------------

    Original Message