Forum Discussion

Mars3442's avatar
Mars3442
Helper I
2 years ago

Lookup multiple times until got the right value

Hi everyone,

I have an issue when I process data in the power query

I have some data: data customer, source data 1, source data 2

 

 

The flow that I used to create this

 to have this expectation

Can I look up multiple times to get the right product code (company) to know the status of the products in the power query?

 

Thank you

Need Help
Tips and Tricks
Tutorial Requests

1 Reply

  • rubayatyasmin's avatar
    rubayatyasmin
    Community Champion
    2 years ago

    Hi, Mars3442 

     

    yeah, you can. Do merge in PQ editor. 

     

    • merge the master data with data customer based on the product code customer
    • This will give you the corresponding product code company for each product code customer.

    then merge with the source data 1 based on Order number and Product Code Company this should give you Status from Source Data 1. Do the same for Source data 2.