Hi,
I currently have a task where I need to calculate thedifference between two sets of data,
The problem is I want to break it down per policy.
For example one policy could have 3 inputs in one set ofdata but only one in the other.
A policy could also appear in one set of data but not theother.
At the minute I am inserting a blank row like the example belowto identify the differences. This is a very manual task and I am sure there isa better way to accomplish what I am doing.
I was wondering could someone help me with some code I coulduse or maybe guide me on the best way to approach this, maybe a pivot.
Any help is greatly appreciated.
Below are examples of my original data and my data followingmy input?
Thanks,
<colgroup><col width="64" style="width: 48pt;" span="3">
<col width="64" style="width: 48pt;" span="3">
<tbody>
</tbody>
I currently have a task where I need to calculate thedifference between two sets of data,
The problem is I want to break it down per policy.
For example one policy could have 3 inputs in one set ofdata but only one in the other.
A policy could also appear in one set of data but not theother.
At the minute I am inserting a blank row like the example belowto identify the differences. This is a very manual task and I am sure there isa better way to accomplish what I am doing.
I was wondering could someone help me with some code I coulduse or maybe guide me on the best way to approach this, maybe a pivot.
Any help is greatly appreciated.
Below are examples of my original data and my data followingmy input?
Thanks,
Policy | € | Type | Policy | Type | € |
AA | € 1.00 | LSR | AA | LSR | € 1.00 |
AA | € 1.00 | LSR | BB | PCP | € 1.00 |
CC | € 1.00 | PCP | CC | PCP | € 1.00 |
dd | € 1.00 | LSR | dd | LSR | € 1.00 |
dd | € 1.00 | LSR | ee | B2B | € 1.00 |
dd | € 1.00 | LSR | ff | LSR | € 1.00 |
Policy | € | Type | Policy | Type | € |
AA | € 1.00 | LSR | |||
AA | € 1.00 | LSR | AA | LSR | € 1.00 |
BB | PCP | € 1.00 | |||
CC | € 1.00 | PCP | CC | PCP | € 1.00 |
dd | € 1.00 | LSR | dd | LSR | € 1.00 |
dd | € 1.00 | LSR | |||
dd | € 1.00 | LSR | |||
ee | € 1.00 | B2B | ee | B2B | € 1.00 |
ff | € 1.00 | LSR | |||
gg | € 2.00 | LSR | gg | LSR | € 1.00 |