Add a new costant field with an Import

Avatar

Avatar

alicep47308254

Avatar

alicep47308254

alicep47308254

20-12-2018

Hello Team,

I need to Import a file with some Recipients and add a new field with a constant value.

For example, I have some recipient in a file and to those recipients I need to assign a country like "IT".

Is that possible? Which action I have to use?

Let me know

Replies

Avatar

Avatar

Jean-Serge_Biro

MVP

Avatar

Jean-Serge_Biro

MVP

Jean-Serge_Biro
MVP

20-12-2018

Hi Alice,


Not in the Upload file activity but in the Update activity, add a new element (here the country code), and in Source Expression type it as static value.

Regards

J-Serge

Avatar

Avatar

asish_kumarp599

Avatar

asish_kumarp599

asish_kumarp599

20-12-2018

A constant can be added in a Load file activity in ACS, You can go to the Column Definition tab add a new column with Value remapping Source value as nothing / blank and destination value as a constant value.