How to have a column always be populated with a string in export files in AEP Destinations

[monika_26]

Hi!!

We are trying to configure new destination with mapping having one column name as "event" equal to a certain string or text as "XYZ in destination export file.

Is there any way we can update the value based on audience or every time this would require setting up a new destination for each audience ?

Is there a way we can leverage the audience files name as an attribute in the export file.
i.e if audience name contains "XYZ" set the column attribute "event" as "XYZ" and if audience name contains "XYZ_ABC" set the value as "ABC".

Or Is there way we can change this value based on audience ID?

I see there is option of add calculated field like below , but not sure what value it contains.
segments[*].segmentID
segments[*].segmentID._id 
segments[*].segmentID.namespace

Would anyone have some suggestions , how we can achieve above ?
We'd really like to have this conditional logic work on the AEP-side instead of having multiple destination for each audience.

Thanks!!

[Parvesh_Parmar · Accepted solution]

Hi @monika_26 , 

If you want to export this value as a field in the file during the mapping step using Profile Attribute-based Mapping, it may be challenging.

As far as I have seen, there is no option to define a formula or conditional logic during mapping — you can only select and export direct fields from the profile.

A pre-calculated field can work if you want to derive values from event data or other profile attributes and store the result in a calculated field beforehand.

However, I don’t believe it is possible to apply conditions directly based on audience membership at the time of export — for example, setting the value to “A” for Audience A and “B” for Audience B dynamically within the same destination mapping.

Kind regards,

Parvesh

[kautuk_sahni]

@monika_26 Just checking in — were you able to resolve your issue?
We’d love to hear how things worked out. If the suggestions above helped, marking a response as correct can guide others with similar questions. And if you found another solution, feel free to share it — your insights could really benefit the community. Thanks again for being part of the conversation!