Merge data in big collections

Forum > Scripting > Merge data in big collections

n/A

postedon April 6, 2015at 9:44 AM

Version 5.3.10

Hello Appway Community,

I have this data-model:

Indexed A $aes;
Indexed B $bes;

I need some sort of built-in function to do this kind of merge:

ForEach $a In $aes Do
ForEach $b In $bes Do
If $a.email == $b.email Then
$a.data := $b.data;
End
End
End

If there is no built-in function, then I need to speed up this script, as the 2 collections can get up to more than thousands of records.
Any ideas?

Thank you!
Mihail

Thomas Suter

repliedon April 9, 2015at 11:06 AM

If you want to solve this problem:

"I have two collections of items 'a' and 'b'. Each item has a "data" and an "email" property.
The email property is unique in each item collection.
I want to find items in the 'b' collection which have the same "email" as the items in the 'a' collection. For each of these items the 'b' item "data" property must be copied to the related 'a' item "data" property. "

then

I'd use a Named collection where the key is the email.
Then you travers the smaller collection.

1Named Whatever $aes;
2Named Whatever $bes;
3Whatever $a;
4For String $email In KEYS($bes) Do
5   $a:=$aes[$email];
6   If $a!=null Then
7      $a.data := $bes[$email].data;
8   End
9End

Generally speaking:
If you have 1000ends of items consider implementing your function in Java.
If you have 100'000ends of items try using a database.

Please sign in to add a reply