Create a variance table bw old and new records

[Inactive User]

Hello community, i'm looking to create a variance/delta sheet between the old and new dataset.

I've used the join tool but have not successfully align the employee+old+new value in the same row.

Appreciate the help in advance!

Table 1
Employee	Attribute	Old Value
A	1	abc
A	2	abc
A	3	abc
A	4	abc
B	1	abc
B	2	abc
B	3	abc

Table 2
Employee	Attribute	New Value
A	1	abc
A	2	defg
A	3	defg
C	1	defg
C	2	defg
C	3	defg

Variance
Employee	Attribute	Old Value	New Value
A	2	abc	defg
A	3	abc	defg
A	4	abc
B	1	abc
B	2	abc
B	3	abc
C	1		defg
C	2		defg
C	3		defg

[Felipe_Ribeir0]

Hi @Inactive User 

One way of doing this

[Inactive User]

@Felipe_Ribeir0, i forgot to mention when the old = new value then it shouldn't appear in the variance table. Your solution doesn't exclude the 'no change' values.

[Felipe_Ribeir0 · Accepted solution]

@Inactive User  

Check this new version.

[Inactive User]

For some reason, this doesn't work on my larger dataset. I keep getting separate rows between the old and the new values even joining all L-J-R.

Variance
Employee	Attribute	Old Value	New Value
A	2	abc
A	2		defg
A	3	abc
A	3		defg
A	4	abc

[binuacs · Accepted solution]

@Inactive User One way of doing this with the join and summarize tool

[Felipe_Ribeir0 · Accepted solution]

@Inactive User 

Could you share the 2 inputs that generated this last table that you shared? Something is strange since the values for employee and attributes are the same on both tables, it is better to understand what is it before proceed.

Maybe you have spaces in the column employee for one of the tables? If this is the case, check using the attached wf.

[Felipe_Ribeir0]

Hi @Inactive User 

It worked?