Exporting labels instead of internal values of enumeration

[parmeshwarr3905]

In campaign classic v7 I have selected the checkbox to export labels instead of enumeration values and still i'm getting the enumeration values in csv file instead of labels. 

I'm exporting extracted data using file transfer to SFTP.

I'm trying to export as 'Yes', 'No' instead of '1', '0' but it's not working, any advise would be appreciated.

[Deb_Tripathy]

Hi @parmeshwarr3905,

Are you getting any errors in the audit of export activity?

One possible solution could be to add an enrichment before the export and have a string column added to it.

In the expression you can write some code (an Iif() shall do) to find the string value based on the integer.

Cheers,

Deb

[parmeshwarr3905]

There is no error.

[DavidKangni]

Check if you're using a boolean type for your field. Which means you don't have any defined enumerations for this field.

Thanks,

David

[parmeshwarr3905]

Yes @DavidKangni the field type is of boolean. could you please suggest how shall I proceed?

[Manoj_Kumar_ · Accepted solution]

Hello @parmeshwarr3905 

You can add this condition in the export expression of your column.

Iif(@COLUMN=1,'Yes' ,'No' )