If condition

[Pomna]

I need help using the if condition. I have a field call Contact Name which has a list of contacts. One contact name appears twice in the following way 

Jan Peters

JAN PETERS

I need this contact to appear only once as Jan Peters

I used the code below which gives me the name as I want it but it also takes away all other contact names. I do not want to lose other contact names. Thanks for your suggestions

If([Contact Name]='JAN PETERS', 'Jan Peters')

[CELAMBARASAN]

Try the below function

Capitalize([Contact Name]) as [Contact Name]

This may help you to solve the scenario.

[nikitadeshwal]

You can below,
if([Contact Name]<>Upper([Contact Name]),[Contact Name]) as Contact_Name
hope this helped you..

[Pomna]

Thanks for the suggestion but it does not solve my problem. Below is my  load script maybe that would shed more light on the issue I have

LOAD

    "Contact ID",

    "Contact Code",

    "ContactType",

    ApplyMap('ContactMap',[Contact]) as [Contact],

    FROM [lib://Warehouse - ContactP/Contact.ContactCustomers.QVD]

(qvd)

[Pomna]

Thanks but it does not solve my problem. I have included my load script may be that would shed more light on the issue am facing

LOAD

    "Contact ID",

    "Contact Code",

    "ContactType",

    ApplyMap('ContactMap',[Contact]) as [Contact],

    FROM [lib://Warehouse - ContactP/Contact.ContactCustomers.QVD]

(qvd)

[CELAMBARASAN]

If you have already applied using mapping load then that should have solve the problem

Or give us an overview what is loaded into ContactMap and what is the issue you are facing the load statement provided.

[Pomna]

The below is what worked for me. Thank you all for the suggestions.

If([Contact Name]=Jan Peters', 'JAN PETERS', )