is there way we can migrate data from one field (boolean type) to another field (string type) | Community
Skip to main content
November 23, 2015
Question

is there way we can migrate data from one field (boolean type) to another field (string type)

  • November 23, 2015
  • 1 reply
  • 849 views

Hi All,

We have one field in Marketo Instance i.e. allowEmail (type Boolean). As per business need we need to create new field with datatype - string. How can I migrate my existing data to new field so that going forward we can use new field.

Thanks,

Abhijit Desai

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

1 reply

Grégoire_Miche2
Level 10
November 23, 2015

Hi Abhijit Desai​,

You can just as smart campaign with the following settings :

  • Smart List : Filter : Is Anonymous = False (all known leads), or any other filter that is suitable to you.
  • Flow step : Change Data value, Field = NewStringField, New Value = {{lead.allowEmail}}

If you want it a little more sophisticated, the Change data value flow step will use a constraint :

  • If lead.allowEmail is True -> New value  = [The value you want to replace "True"]
  • Default : New Value = [The value you want to replace "False"]

Run it once

-Greg