RPL loop data within loop data
in Responsys
I am having trouble with an RPL loop inside an RPL loop.
My setup is as follows:
SQL view campaign_dist (filters only members of this particular campaign)
Contains CUSTOMER_ID
SQL view campaign_members_distinct (contains deduped/distinct list of campaign members)
Contains CUSTOMER_ID, POLICY_NUMBER, MEMBER_NAME, PRODUCT_NAME, PRODUCT_TYPE
One Customer ID can match to many POLICY_NUMBERs
SQL view campaign_policy_lookup (contains all data)
Contains all data, not deduped
Each member might have multiple policies, so this requires us to loop the policy data under the a loop of members. This way we end up with a header for each member, and a listing of the policy information below their name
0