Update Main Database Field using Relational table field
I was wondering if there is an easy way to update main database Field with values from a variable within Relational table.
Main database: AB
Main database field to update: AB_Segmentation
Relational database: BC
Relational database field to update: BC_Segmentation
So I want to update AB_Segmentation with values in BC_Segmentation for all records within AB Database
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.
Please sign in to leave a comment.