Avatar

Level 6

Personnaly, I would have suggested you to use a dataloading activities for importing a CSV file with your custom fields but be sure to have a column with the recipient Id (or another field to identify your recipients) in it.

If we can say that "1 line from the CSV = 1 recipient" then it will be easy: after the file import, just use a enrichment activity.

Open it and go on the 2nd tab ("Reconciliation"), select "use simple reconciliation key",

select "recipient" as targeting dimension,

select the column of your "recipientId" in source expression and "recipientId" as destination expression.

Now you no more have just "columns" in your workflow but "recipients with new columns": you can add your delivery but be sure that all your "special" columns are coded this way "targetData.mySpecialColumn".

 

if this is for a "one shot" delivery I wouldn't create a dedicated schema for that but prefering to use the most simple tools without having to alter the structure of the database