Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a data which includes Policynum and Module. When the policy renewes it is assigned a new mod .
In the attached sample Policynum '1701655 ' have 10 modules. I wanna the data set to always come back with only the latest module entries.
In the attached sample I would like to see only one row
PSL 1701655 10 330
Attached please find the Sample QVW and QVD
Hi,
Please see the attached.
add to your script
Right Keep (Policy)
load POLICY0NUM_CONSOLIDATED, MaxString(MODULE) as MODULE Resident Policy Group by POLICY0NUM_CONSOLIDATED;