Hi
Can somebody assist me these Questions please? Data is attached.
1) Import tables: ClaimsListing, ClaimsMaster, RegionDescription.
PS - Note that the delimiter is ','
2) The description for "CLAIM TYPE CODE" is in the table GetClaimType
3) Display the Excesss Total Value per Unique Claim entry on the ClaimsListing table by adding the different type of Excesses together.
4) Ensure your date selection has an option to view data by Incident Period (MM/YYYY).
5) Display the total of "AUTHORISED AMOUNT" for all claims of which the "INCIDENT DATE" fell within the date range of each
Catastrophy start and end date (Excel Document 'Catastrophy Incidents'). If the "AUTHORISED AMOUNT" is R0, use the field "CLAIMED AMOUNT" as a value.
For this view, you should only include claims where the CLAIM STATUS is not equal to 'R' or 'Z'.
6) Use the Claims data to provide useful views.
-----------------------------
Please see: https://drive.google.com/open?id=1wk7AUNXITIsrzoY6uDgMxMFrvc-dO7n3 … AND https://drive.google.com/open?id=1Bdq0jxJ0g5cXg2jK_1YjUlr-josKXnkD …
