Query Looping/Iterations RRS feed

  • Question

  • Hello Everyone/Anyone:

    I am new to power query but have learned quite a bit. I am struggling with a new issue that I need help with ASAP! I will try and explain what I need the best possible way.

    Query #1: Web query pulls data based on a filter value of a single Dispatch type "PM's"

    Query 2 would pull the Labor cost for each PM. The labor cost is pulled from a different web query with the common connection of the "Dispatch#" in column 1 and cannot be filtered by dispatch type, so merging queries works but I have to pull 100's of thousands of records to find all the matching dispatch #'s.

    To clean this up I want to use the "Dispatch #" as the parameter from Query 1 and iterate through each dispatch number to pull the labor cost in Query #2.

    I am lost and don't know where to start. Can Someone please help with this?


    Thursday, September 17, 2020 2:25 PM