How can I batch change a Field based on Opportunity Name?
We are doing some data cleanup while implementing Marketo. We have a opportunity field called Product. We need to batch update that field based on a word that is in the name of the opportunity. For example:
Opportunity Name Contains the word "Pilot" = Change the product name field to "Pilot"
We have about 5K records that need to be changed. Can someone provide a solution? I'm noticing that under the FLOW, we are unable to select Opportunity Name under a Change Data Value flow step.
Any help would be greatly appreciated.
Thanks,
Ron