SOLVED

Re: How to search and replace a value in the database?

Go to solution
Kaye_McClendon
Level 3

How to search and replace a value in the database?

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Darshil_Shah1
Level 10 - Community Advisor + Adobe Champion

Re: How to search and replace a value in the database?

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.

 

View solution in original post

1 REPLY 1
Darshil_Shah1
Level 10 - Community Advisor + Adobe Champion

Re: How to search and replace a value in the database?

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.