You’re offline. This is a read only version of the page.
Announcements
2
Hi all,
I have two versions of an Excel table that I want to compare head-to-head via Power Query merge full outer. The result I would like to get is the following:
| Table 1 | Table 2 | Merged | table | |||||
| Index | code line | Index | code line | Index | code line.table 1 | code line.table 2 | ||
| C2A3 | a=3 | C2A3 | a=3 | C2A3 | a=3 | a=3 | ||
| E2R4 | b=4 | 2W2W | c=a+b | E2R4 | b=4 | - | ||
| 2W2W | c=a+b | 9LW2 | print a | 2W2W | c=a+b | c=a+b | ||
| 9LW2 | print c | TR45 | c=c+1 | 9LW2 | print c | print a | ||
| TR45 | - | c=c+1 |
I know how to do a full outer merge (based on the index column), but I would like to keep the original order of code lines. If I do this with power query, then the rows are not exactly in this order anymore. The goal for me is to see which lines have been removed (E2R4), which lines have been updated (9LW2), and which lines have been added (TR45).
Does anyone know a good solution in Power Query? Thanks in advance
Share
Report
All responses (
Answers (
