In the world of insurance, I'm stuck with having to link claims table from suppliers by the policy number onto the risk details table.
The claims table can have multipule claims per policy, and as the claims file does not have the cover period of a policy, a policy number can appear numerance times as the policy is renewed.
when merged, only for the numeric fields, keep one entry then replace the duplicate entries with null.
This currently has me little bit stumped (I'm rather new to Power Query).
Thank you in advance for your time
You may take a look at the post below.