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 | |||||
Solved! Go to Solution.
Hi Yalmar,
I m unable to unzip this file, I use, 2018.2 hope your version is latest. Can you help
Thanks
Raj
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.
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)
Thank you Yalmar