Hi. I have this scenario, where by I am loading a list of unmatched payouts from Airtable. Then, I am trying to match them to another table containing Bank Transactions, based on certain conditions. Depending on how many matches found, I want to do different logic.
- If 0 matches, mark the payout as unmatched
- If 1 match, mark the payout as matched, and link to the matched transaction
- If >1, save a list of IDs in a field, so it can be matched manually.
When I use an Text Aggregator, it seems to be passing always from one route.
I also lose the ability to check for the bundles.length after the aggregator. Any advice on how this an be done?