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

Question
11
Views
0
Comments

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!