Comparing the versions of two tables

(0) Share

Report

Posted on by Ruud14

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