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

How to search and replace a value in the database?

  • May 20, 2020
  • 1 reply
  • 1814 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
Darshil_Shah1Accepted solution
Community Manager
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.