Exporting labels instead of internal values of enumeration | Community
Skip to main content
P
parmeshwarr3905
Level 3
April 12, 2022
Solved

Exporting labels instead of internal values of enumeration

  • April 12, 2022
  • 3 replies
  • 1918 views

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.
Best answer by Manoj_Kumar

Hello @parmeshwarr3905 

 

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

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

3 replies

D
DebTr
Level 6
April 12, 2022

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

P
parmeshwarr3905Author
Level 3
April 12, 2022

There is no error.

DavidKangni
Community Advisor
DavidKangniCommunity Advisor
Community Advisor
April 12, 2022

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
P
parmeshwarr3905Author
Level 3
April 12, 2022

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

Manoj_Kumar
Community Advisor
Manoj_KumarCommunity AdvisorAccepted solution
Community Advisor
April 13, 2022

Hello @parmeshwarr3905 

 

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

Iif(@COLUMN=1,'Yes' ,'No' )
Manoj  | https://themartech.pro
Terms & ConditionsAccessibility statement

Loading footer...