Update Main Database Field using Relational table field


1 comment

  • Geoff Schemel

    I would approach it in different ways depending on what the data is you are looking to write.  If the data is a small set of options, you could write a Program that uses Decision Points and Profile Updates to do this.  So if the data is a value of 1 - 5, you could then do something like "if the data value is '1' then make the database field a '1'.  Once this Program is setup, you can just run the contacts in the Database through it to update the field.

    However, if the there's a large variety of data within that field, it may be easier to just export the Relational Table and then import that field back into the database. 

    Comment actions Permalink

Please sign in to leave a comment.