Dynamically determine number of User-Subscriptions

Question

Dear Community,

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?

I very much appreciate your contributions.

* The Input sample and Workflow are attached

Date_Duplicates_Sample.xlsx

Unique_User_Records.yxmd

grossal · Accepted Answer

Hi @Desa19

you were really close to the solution, only three more tools were needed.

1) Unique Tool to remove the duplicates

2) Summarize Tool (before transposing) to count the subscriptions

3) Join tool in the end to bring them together

(and I added a browse tool in the end ;-))

I have added the tools to your sample workflow.

If this solved your problem, please mark it as a solution or drop another question if it did not solve it.

Alex

PS: You are right now in the German forum 😉