I have to load data based on condition like
If the customer is enrolled to both P1 and P2 policies, then load only P2.
1. Every Customer has only two policies or it will be more policies Ex (P1,P2,P3....)
2. Will it be only two policies P1,P2.
LOAD * INLINE [
'P'&Max(right(POLICY_NO,1)) as POLICY_NO
Group By CUSTOMER;
Drop Table data;
I think the main component here would be DATES!
I assume your exact requirement would be to load latest Policy taken?
If not please confirm your exact requirement
Check below script
Maxstring(POLICY_NO) AS POLICY_NO
GROUP BY CUSTOMER;
If you have more than policy per customer and may be two simple do this in UI part for the customer
Retrieving data ...