How to setup Bridge Junction for Update Row w/ multiple matches
I am trying to leverage Bridge to update all cells of a column where there is a matched ID between a source sheet and a destination sheet. In this scenario there would be multiple matches in the destination sheet.
I'm struggling to determine how the Bridge workflow would identify which rows in the destination sheet to update. I've tried using both 'Get Row' (for the source sheet information) and 'Get Sheet' (for the destination sheet information), then pair possible data references for matches against the updated row (source).
- Which conditional junction would you use and how would you set up the criteria / states?
- Is Bridge limited to only updating the 1st found match, or is it possible for an Update Row to be executed for multiple matches in a single run?
Thanks for the help,