Expand my Community achievements bar.

SOLVED

Assigning multiple enum values to one label

Avatar

Level 1

Is it possible to assign multiple enum values to one label? We have various spellings of the same value (ex. vp-level, VP-level, VP-Level) across our data but I would like to display only one version (ex. VP-Level) in the attribute drop-down list. I tried to do this by adding all the enum values and pointing duplicates to the same label but I end up with an equally long drop-down. My goal is to have a clean and condensed drop-down list without missing any contacts due to discrepancies in spelling. Is there another way to achieve this?

E_Taylor_0-1662593473620.png

E_Taylor_1-1662593840220.png

 

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Right so based on where you would use it, there are couple of options. 

 

a.) Segmentation/Profile Usage: Modify at source level, i.e a you format the "raw data" before ingestion using the Data prep. Create a regex of those possible values to match against raw data, if true return "VP-Level". 

b.) For reporting purpose (CJA): This would be a component setting feature, where you could create rules to match similar items. 

 

Hope that helps 

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

Right so based on where you would use it, there are couple of options. 

 

a.) Segmentation/Profile Usage: Modify at source level, i.e a you format the "raw data" before ingestion using the Data prep. Create a regex of those possible values to match against raw data, if true return "VP-Level". 

b.) For reporting purpose (CJA): This would be a component setting feature, where you could create rules to match similar items. 

 

Hope that helps 

Avatar

Community Advisor

@E_Taylor when you create the Enum field, create with the standard value. During the data ingestion apply the transformation during the data preparation step to map correctly. 

How are you ingesting the data? Batch or streaming?