Expand my Community achievements bar.

SOLVED

Exporting labels instead of internal values of enumeration

Avatar

Level 3

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.

 

parmeshwarr3905_0-1649775676697.png

 

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hello @parmeshwarr3905 

 

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

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

     Manoj
     Find me on LinkedIn

View solution in original post

5 Replies

Avatar

Community Advisor

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

Avatar

Community Advisor

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



David Kangni

Avatar

Level 3

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

Avatar

Correct answer by
Community Advisor

Hello @parmeshwarr3905 

 

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

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

     Manoj
     Find me on LinkedIn