Your Achievements
Level 1
0% to
Level 2
Next /
to gain points, level up, and earn exciting badges like the new Applaud 5 BadgeLearn more!
View All BadgesSign in to view all badges
Open Alert Bar

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

Anonymous
Not applicable
‎11-23-2015 02:43 AM
‎11-23-2015 02:43 AM

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

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

0 Likes
528
Reply
1 REPLY 1
Grégoire_Miche2
Level 10
Level 10
‎11-23-2015 05:22 AM
‎11-23-2015 05:22 AM

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

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

457
Reply
Home