How to search and replace a value in the database? | Community
Skip to main content
Kaye_McClendon
Level 3
May 20, 2020
Solved

How to search and replace a value in the database?

  • May 20, 2020
  • 1 reply
  • 1823 views

Thousands of students are assigned to an specific admissions counselor. However, that counselor has left and we know how to reassign all of those students to a new counselor. What's the easiest way to search and replace a value in the Marketo database?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Darshil_Shah1

If you are referring to searching and changing the field value in marketo then you can create a Batch Campaign with smart list filter as "<field name>" is "Old Value" and set the flow step as Change Data Value <field name> and set as <new value>.

Ref. for Change Data Value Flow step. I believe this is the best approach.

 

1 reply

Darshil_Shah1
Community Advisor and Adobe Champion
Darshil_Shah1Community Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
May 20, 2020

If you are referring to searching and changing the field value in marketo then you can create a Batch Campaign with smart list filter as "<field name>" is "Old Value" and set the flow step as Change Data Value <field name> and set as <new value>.

Ref. for Change Data Value Flow step. I believe this is the best approach.