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
  • 1834 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
Adobe Champion and Community Advisor
Darshil_Shah1Adobe Champion and Community AdvisorAccepted solution
Adobe Champion and Community Advisor
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.