Forum Discussion
Merge Queries - fastest method
Hi Anonymous ,
1.In the Table 1, select the Merge Queries.
2.Select the Cod column in both tables, and then click OK.
3.Expand the column.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
What kind of join/merge are you using, and what are you actually joining?
--Nate
Anonymous
I try to do a VLOOKUP in a Power Query, but waste a lot of time.
For Example i have table 1:
Cod Name 1 Gary 2 Ferdinand 3 Paolla I try do cross to table 2:
Cod color 1 Blue 2 Gray 3 Green I want try to do this more faster.
Hi Anonymous ,
1.In the Table 1, select the Merge Queries.
2.Select the Cod column in both tables, and then click OK.
3.Expand the column.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
In Table 2, add a custom column and add the code below:
- Table.SelectRows(Table1, (x)=> x[Cod]=[Cod])[Name]
Regards
KT
