I have a summarized list of Subscribers(User-IDs) with the corresponding history of subscriptions (validity from date -Till date ). In the Workflow attached i have summarized the rows of subscriptions to just one unique row per Subscriber, each subscription now represents a column, the number of columns grows dynamically with time based on number of subscriptions.
However there are 2 issues i am yet or unable to solve:
1- How to avoid repeating the same subscription period on different columns for same user. Though this represents a realistic scenario based on the data (since some Users subscribe for 2 different products within same time frame or sometimes just due to errors while trying to subscribe), I however would like to avoid a repetition of same subscription period in another column, examples are the cases with Users 242 and 297.
2- How can I include a column that dynamically determines the number of subscriptions a User has made till date based on the Subscription history of the user?
first of all thanks a lot for your assistance and the smart proposal, it just exactly solves my problem.
I must admit that sometimes it is better to think with less complexity, I am quite embarrassed that I could not figure using a simple Grouping and frequency tool (Summarize), then ultimately do a join 🙂