Update Main Database Field using Relational table field

Follow

N15578

• November 29, 2022 14:25

Hi,

I was wondering if there is an easy way to update main database Field with values from a variable within Relational table.

Example.

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 

0

• 

  Geoff Schemel

  • December 22, 2022 21:34

  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. 

  0

  Comment actions Permalink

Please sign in to leave a comment.