Hi guys!
I was missing here, but I came back!
I need some help from you… Loop to a project that need add a number that have a start and need to increase 10% from this start (like I’ve 100, next mark will be 110 and so on…).
The propous is to create a warmup process for emails and I’ve a list of unique contacts that I’ll flag some stages. So If I’ve 1000 contacts and start with 100, I need to mark a flag as 1,2,3,4… that will be between 100 to 110, 110 to 121 and so on…
I think something simple, as a loop to make calcs and after that, use row lenght to make these marks/flags until the EOL.
But I’m stroke here… How can I use loops nodes to make it simples? maybe a recursive loop one? but I didn’t understand yet how to use it correctly. Pickup the last result, calc and go to next step with the last result.
Did I have made me clear here? lol
Some suggestions?
Thanks
Hey there,
just to clarify - you want to create some sort of “Buckets” - i.e. you have 1000 rows of contact data.
Starting from 100 you want to have groups size of 10 - so first group is 100 till 110, after that you want to increase the group size by 10% of the end of the last group so second group is 110 till 110 x 1.1 = 121, next group is 121 till 121 x 1.1 = 133, then 133 till 133 x 1.1 = 146?
so in your data set it could be
Contact no | Group
109 | A
110 | A (or B?)
111 | B
112 | B
…
121 | B (or C?)
122 | C
…
Well I may have absolutely misunderstood, but if not - here is something that does the job - I made the decision though that each of the 1000 contacts can only be in one group though - so it is 100-110, 111-121, 121-…
Image:
Workflow:
NumberBuckets.knwf (113.1 KB)
Hi @MartinDDDD , you shot nearby.
As the table below as an excel example:
If I create limits with numbers, I can match with row index to make a loop. Exemple 0 to 400 will be set as 1, 400 until 440 will be 2, 484 will be 3 and so go on…
After that, I’ll have a contacts book with a email column that I need to limit/flag with the group number for next step, break it a part by group…
To make it match numbers is not the problem, but a away to create this logical as a loop or something that I know the start number, the end number, but I need to create groups numbers that I’ll calc and set until the limit, like something as recursive or progressive using the last number solved as the start number again… like a range limits.
Could I make more clear? sorry if my english is not so well… lol
Thanks,
Denis
