hi everyone,
How can i join by a key value the results bundles of 10 operations, each operation has 1000 records.
i tried iterator then text aggregator but the outputs bundles in different operations doesn’t join in a unique key value.
Thanks in advance.
Hey Magnus_Maker,
Have you looked into using the slice(), merge() and possible map() functions? If yes, can you give me an example of the output what you want? For example, do you want certain key-value pairs from different bundles to be merged into one single array?
I think your problem is definitely solvable. - VDW Intelligence
hi @vdwintelligence thanks for the reply.
i will try to explain.
my Database use OFFSET to the HTTP call upto 1000 records.
so i used a repeater to grab all the records in 6 loops because i have 6000 records.
then i need to group the records by customer then filter who pays one month but do not pay the following month.
Ex.
Joe
Jan25
Feb25
Mar25
Jun25
Mary
Jan25
Feb25
Mar25 (in loop 1 of 1000 records)
Apr25 (in loop 2 of 1000 records)
May25
Jun25
So i need to filter all the costumer that paid March but no paid on April (Just Joe). and put the name in the colum A in a Spreedsheet.
the problem is: that make read the bundles in packages of 1000 so if the payment is in a different packages of bundles the filters didn’t work. So Joe and Mary pass through the filter.
I hope you can get the idea.
Thanks in advance.
Hi Magnus,
Thank you for the clarification, that makes the problem way more complex than I thought at first glance.
I tried to really understand your problem, but it still seems a bit messy for me (which is understandable, these type of questions are hard to explain and clarify via message).
Unfortunately, I am not able to come up with a solution… I hope someone else can after your clarification.
The best of luck with solving the problem, and I am really sorry that I can’t help you further - VDW Intelligence
Hey @Magnus_Maker
Please share your scenario screenshots and modules explanation so we can help!
Best,
@Prem_Patel
@vdwintelligence don´t worry thanks anyway for your comments.
Hi @Prem_Patel thanks for your reply.
here is a screenshot (i can´t share the download files because there is sensitive info.)
I hope my scenario explanation helps
(Sorry for my english)
It will be great if you can share 1 screenshot of execution from history. As at first look, it looks like if you’re getting 6 different bundles with HTTP request, you have to use HTTP as source module in Text aggregator.
Thanks @Prem_Patel at the end i used a sheet to compares bouth months directly and it works.
Glad that it helped! @Magnus_Maker
