Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
COMP_CODE | CS_COMP_CODE | CLM_COMP_CODE | COMP_NAME | LYTD Claims |
423423689 | ||||
1 | 1 | 1 | XYZ Company | 130105870.7 |
1 | 6 | 6 | XYZ Company | 758898.667 |
2 | 2 | 2 | XYZ Company, Dubai | 248525030.4 |
3 | 3 | 3 | XYZ Company, Abu Dhabi | 36960129.95 |
5 | 5 | 5 | XYZ Company | 943114.697 |
6 | 6 | 6 | XYZ Company | 3990743.397 |
- | 1 | 1 | - | 42805.3 |
- | 5 | 5 | - | 1013763.197 |
- | 6 | 6 | - | 1842231.443 |
Comp_Code is from the master table. cs_comp_code and CLM_comp_Code are from different tables.
Error : The results are splited out in different rows. first 3 columns should have same code. LYTD claims should have consolidated value eg: Actual result for CompCode should be 130105870.7 + 42805.3, but they r in different rows, when i try to link with other tables loops are being formed. Pls help
Message was edited by: jasmine Glory
Can you post sample app
Put an example please or explain more, will be easier to help you
Fernando
Hi Jasmine,
There are some records without value for COMP_CODE, it's hard say a solution without more info, in script you can try something like:
If(IsNull(COMP_CODE), CS_COMP_CODE, COMP_CODE) as COMP_CODE
or loading the field 'CS_COMP_CODE as COMP_CODE' when you read the source data without value in COMP_CODE
Hope this helps you to find the right solution.
Regards.
COMP_CODE | CS_COMP_CODE | CLM_COMP_CODE | COMP_NAME | LYTD Claims | Comments |
423423689 | Total Value | ||||
1 | 1 | 1 | XYZ Company | 130105870.7 + 42805.3 | last but 3rd row should be added here with codes 1,1,1 in the first 3 columns |
1 | 6 | 6 | XYZ Company | 758898.667 | This row should not be there (duplicate) |
2 | 2 | 2 | XYZ Company, Dubai | 248525030.4 | No change |
3 | 3 | 3 | XYZ Company, Abu Dhabi | 36960129.95 | No change |
5 | 5 | 5 | XYZ Insurance Company | 943114.697 + 1013763.197 | last but 2nd row should be added here |
6 | 6 | 6 | XYZ Company | 3990743.397 + 1842231.443 | No change |