Hello
I have a process that I need to finish and where I have to loop through two collections. [Coll1] has data from data base that I try to find match/similarity to [Coll2] - input from customers. Then when finds match it can continue to chew and compare more rows between those.
I take first row from [Coll1] and loop from the top to the bottom of [Coll2] to find match for that row from [Coll1] on [Coll2]. I am using Count ++ on [Coll2] each time it read row.
For the moment I have [Coll1] with 20 rows looping through [Coll2]with 7 rows.
But the idea is to get the loop work no matter how many rows there are on each of these.
How can I get the count for main collection work? So I can loop through collections no matter the row count.
Or should I check the collections some other way?
I have a process that I need to finish and where I have to loop through two collections. [Coll1] has data from data base that I try to find match/similarity to [Coll2] - input from customers. Then when finds match it can continue to chew and compare more rows between those.
I take first row from [Coll1] and loop from the top to the bottom of [Coll2] to find match for that row from [Coll1] on [Coll2]. I am using Count ++ on [Coll2] each time it read row.
For the moment I have [Coll1] with 20 rows looping through [Coll2]with 7 rows.
But the idea is to get the loop work no matter how many rows there are on each of these.
How can I get the count for main collection work? So I can loop through collections no matter the row count.
Or should I check the collections some other way?
Last edited: