Link to home
Start Free TrialLog in
Avatar of Patricia Timm
Patricia TimmFlag for United States of America

asked on

I have 2 tables in power query I want to comare the id column in each table and find the matches

I have 2 tables in power query I want to comare the id column in each table and find the matches? How do I do this?
Avatar of Tom Farrar
Tom Farrar
Flag of United States of America image

You use the merge option, and choose the type of join.  If you right-click one of the queries that created the tables you can choose the merge option.
ASKER CERTIFIED SOLUTION
Avatar of Tom Farrar
Tom Farrar
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Patricia Timm

ASKER

Thanks!