Power Query - Match rows

[VanithaGovindan]

Hi Team, 

I've a clarification . In VBA we are using matchrow. row Function . How to implement the same in power query .

There are 2 tables. Name it Table A and Table B.   Both the table has same columns  Example - Status. 

If in Table A , Eg the status of XXX - Open and in Table B- ths status of XXX - WIP/Closed. i need to update the status of the XXX without affecting other columns, Instead the column status of XXX should get changed to WIP/Closed .  Only if there are any change in the status from Table B , the data should get populated in Table A. so that other data remains same . 

Please advise 

Thanks 

Vanitha G 

[aduguid · Accepted solution]

Sounds like you just need to merge the 2 queries. When you merge, you typically join two queries that are either within Excel or from an external data source. In addition, the Merge feature has an intuitive user interface to help you easily join two related tables. For an example of merging total sales from an order details query into a products table.

https://support.microsoft.com/en-us/office/merge-queries-power-query-fd157620-5470-4c0f-b132-7ca2616...