Variance report- compare two set of columns

[Raj_2]

Dear All,

I am working two spreadsheets with two different spreadsheets, one with 300 records and another 1200 records. I am joining this reports and getting into one and then need to compare two coloumns. But not getting the report in proper shape. Below is the samples. Geeks, please help

what i did is joined both but not getting complete entries, while joining. Need to sort and then compare paycode and amount.

Any difference inadvised and paid with same emp id with same paycode amount needs to flag as variance.

Emp id	Pay elements	Amount	Status		Emp id	Pay elements	Amount	Status
1001	Base pay	1000	Advised		1001	Base pay	1000	Paid
1001	Normal hours	15000	Advised		1001	Normal hours	15000	Paid
1001	Car pay	2400	Advised		1001	Car pay	2400	Paid
1001	HRA	26000	Advised		1001	HRA	26000	Paid
1001	Tax	12000	Advised		1001	Tax	12000	Paid
1002	Base pay	1000	Advised		1001	Gross Salary	200000	Paid
1002	Car pay	20000	Advised		1001	Gross deductions	30000	Paid
1002	HRA	30000	Advised		1002	Base pay	1000	Paid
1002	Normal hours	4000	Advised		1002	Car pay	20000	Paid
1002	Tax	3000	Advised		1002	HRA	30000	Paid
					1002	Normal hours	4000	Paid
					1002	Tax	3000	Paid
					1002	Gross Salary	200000	Paid
					1002	Gross deductions	30000	Paid

[yalmar_m]

Hi @Raj_2

Might this solution be helpful for you?

Best,

Yalmar

[Raj_2]

Hi Yalmar,

I m unable to unzip this file, I use, 2018.2  hope your version is latest. Can you help

Thanks

Raj

[yalmar_m]

Dear @Raj_2,

Is this screenpicture clear enough?

[Raj_2]

Thank you :),It is opened and the output is kind of expected. Only one addition how can I get both inputs in output file, both advised & paid and then the variance status.

[yalmar_m · Accepted solution]

If you put in the checkmarks in the join-tool it displays all values.

Though you might want to rename the paid colums (otherwise you have for example Right_emp id)

[Raj_2]

Thank you Yalmar