Skip to main content
Topics#Data ManagementGerald Kurkoski's Question
Gerald Kurkoski (Xcel Energy) asked in #Data Management
Sep 13, 2012, 4:33 PM

Decode imported data values to other values.

We are importing data to a Custom Field. The data is coming in as 0, 1, 2 and should decode-display as

 

0 = unknown

 

1 = Rents

 

2 = Owns

 

Can I do this as a calculated field or can I decode the data and present it in the same field?
2 answers
  1. KC Shafer (2U)
    Sep 13, 2012, 4:38 PM
    If that is how you are going to be importing it, then you should hide that field on the page layout and have another custom formula field, returning text with a formula of:

     

    CASE(

     

    customfieldname__c, 

     

    1,"Rents",

     

    2,"Owns",

     

    "Unknown"

     

    )

     

    Then display that field on the page layout, that would be the easiest way if you intend to continue moving data in with the numeric values. 

     

    --KC
Write an answer...
0/9000