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 EmployeeAttributeOld ValueA1abcA2abcA3abcA4abcB1abcB2abcB3abc Table 2 EmployeeAttributeNew ValueA1abcA2defgA3defgC1defgC2defgC3defg Variance EmployeeAttributeOld ValueNew ValueA2abcdefgA3abcdefgA4abc B1abc B2abc B3abc C1 defgC2 defgC3 defg

Create a variance table bw old and new records

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

Workflow

Transformation

Batch Macro

Join

Accepted answers

Felipe_Ribeir0

@Inactive User

Check this new version.

Create a variance table bw old and new records.yxmd

binu_acs

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

Join_1017.yxmd

Felipe_Ribeir0

@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.

Create a variance table bw old and new records.yxmd

All comments

Felipe_Ribeir0

Hi @Inactive User

One way of doing this

Create a variance table bw old and new records.yxmd

unknown

@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.