Log In
Register
Home
August 21, 2019
Offline
Hi Catalin / Mynda
In Excel, I can use
=IFERROR(INDEX('Table 1'!B:B,MATCH(A2,'Table 1'!A:A,0)),INDEX('Table 2'!B:B,MATCH(A2,'Table 2'!A:A,0)))
How about in Power Query,
See my attached excel, source query done half way, what is the best method to put album and details in two columns
November 8, 2013
Offline
Hi Chris,
Append Table2 to Table 1, this will create a single table with all data. Use this single full table to merge it with the single column table.
August 21, 2019
Offline
Hi Catalin,
Yes, however in real life, the Table 1 and Table 2 and subsequent tables are with different headers, by appending them together will be very messy, so is there an equivalent M Code for
=IFERROR(INDEX('Table 1'!B:B,MATCH(A2,'Table 1'!A:A,0)),INDEX('Table 2'!B:B,MATCH(A2,'Table 2'!A:A,0)))
or nested loop for looking up values from one table to another.... if UI cannot do it
November 8, 2013
Offline
I really cannot see the problem you see. You just have to rename the columns that have the same data before append, the append will work.
Provide samples closer to reality, this will help you get a more useful answer.
1 Guest(s)
