Substitute values

[#1]

Hi,

I have a field called Inactive_Contact__c where the values are true or false.

eComContacts:

LOAD Id as ContactId,

    AccountId,

    Inactive_Contact__c,

    Business__c,

    Name;

SQL SELECT *

FROM Contact

WHERE AccountId != NULL;

How do I convert all the true values to YES and all the false values to null or -?

[ramoncova06 · Accepted solution]

you can use an if statement

eComContacts:

LOAD Id as ContactId,

    AccountId,

    if(Inactive_Contact__c = 'True','YES', null()) as Inactive_Contact__c ,

    Business__c,

    Name;

SQL SELECT *

FROM Contact

WHERE AccountId != NULL;

another option is to use wildmatch

[#3]

thanks ramon