Level 3

Solved

Exporting labels instead of internal values of enumeration

5 replies
1917 views
Translate

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.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

_Manoj_Kumar_Accepted solution

New Participant

Hello @parmeshwarr3905

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

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

Manoj Find me on LinkedIn

_Manoj_Kumar_Accepted solution

New Participant

Hello @parmeshwarr3905

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

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

Translate

Manoj Find me on LinkedIn

DavidKangni

New Participant

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

Translate

David Kangni

P

parmeshwarr3905Author

Level 3

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

Translate

D

DebTr

Level 6

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

Translate

P

parmeshwarr3905Author

Level 3

There is no error.

Translate

Sign up

Login with SSO

Login to the community

Login with SSO