background shape
background shape

How to map enumeration with file extract

I was recently asked about the purpose of a checkbox, and believe it or not, it turned out to be the function I thought was missing in Adobe Campaign Classic – but it’s actually there.


It’s the File Extract activity feature hidden in one of the final steps of the extraction wizard. It is simple checkbox options that automates the remapping of enumerations to their string values. Before (sigh), I used JavaScript expressions for this, unaware that the same outcome could be effortlessly achieved with a mere checkbox.

Adobe Campaign Classic - JavaScript expression extract data definition settings

It was right there in front of my eyes the entire time, nicely hidden in plain sight. On the Destination Format step, take a look at the last checkbox. Yes, that’s the one! It exports labels instead of internal values for enumerations. Now that I know, for my next extract, I’ll use this option instead of manual mapping.

Adobe Campaign Classic - extract data encoding settings

My last unanswered mystery is this: I’m curious to know whether this particular functionality has been an integral part of the system since its inception or if it subtly made its way into the mix through subsequent product updates.

Meme: There is a checkbox for this

Oh hi there 👋
I have a FREE e-book for you.

Sign up now to get an in-depth analysis of Adobe and Salesforce Marketing Clouds!

We don’t spam! Read our privacy policy for more info.

Share With Others

MarTech consultant

Marcel Szimonisz

Marcel Szimonisz

I specialize in solving problems, automating processes, and driving innovation through major marketing automation platforms.

Buy me a coffee
Subscribe

Oh hi there 👋
It’s nice to meet you.

Sign up to receive awesome content in your inbox, every month.

We don’t spam! Read our privacy policy for more info.

If the form isn't cooperating, don't worry. Just drop us an email at info(at)martechnotes(dot)com with 'Subscribe' in the subject line, and we'll be happy to add you to our list. As a token of our appreciation, we'll also send you a free e-book. Your subscription means a lot to us, and we want to ensure you don't miss out on our valuable content.