Multiple value attribute in an Email content in SAP Marketing cloud

[former_member606752]

We are creating Email content. We are using Personalization feature in it. In the Email content we are adding Multiple value attributes (e.g): Interaction date or Interaction Type . A contact may have number of interactions and Interaction dates.

Suppose we are using Interaction date attribute in the Email design. When a Email is sent to the contact ,the Email is displaying all the interaction date of the contact with commas in between each date. Is there a way to restrict the multiple value attribute to display only single value like the latest interaction date instead of all interaction dates?

[maik_bosch · Accepted solution]

Hi Venkatesh,

I guess for this you have to create a custom hana view with a new attribute which is showing exactly the value you want for this contact.

BR

Maik

[former_member606752 · Accepted solution]

Thanks Maik. Any documents to create a custom hana view ?

[maik_bosch · Accepted solution]

Hi Venkatesh,

I really like those blogs:

https://blogs.sap.com/2016/07/18/build-and-import-sap-hana-views-for-segmentation-in-s4hana-marketin...

https://blogs.sap.com/2016/07/18/building-and-importing-sap-hana-views-for-segmentation-in-s4hana-ma...

https://blogs.sap.com/2016/06/29/setup-of-sap-hana-database-in-sap-hana-cloud-platform-trial-account...

Custom Views in Segmentation

And there is nice one here aswell:

https://www.sap.com/cxworks/article/453913143/How_to_Model_Custom_SAP_HANA_Views_for_SAP_Marketing_C...

BR

Maik