A threshold based approach to merge data in financial risk management