You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

RPL loop data within loop data

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

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!