IF formula in the data load editor

[JOHN123]

Hi,

I have a client that had a name change in 2019. Now when viewing all the results from last year, the client that had a name change data is split up over the old and the new name and I want to write a "IF" formula that see's all the data for this client as one name. I have the following formula in place, but keep on getting the same error.

(Just using clientoldname and clientnewname for privacy)

Formula:

If(ShipmentClientDescription=Clientoldname,clientnewname) as ShipmentClientDescription,

I then get the error:

Feild "Clientoldname" not found.

I am using the formula correctly?

Thanks,

[Taoufiq_Zarra]

If(ShipmentClientDescription='Clientoldname','clientnewname') as ShipmentClientDescription,

[davidfdezcalleja]

Hi John,

you can use this example:

IF(Condition, then, else)

IF(  [producto]='XXXX'  ,  'YYYY'  ,   [producto]  ) as  [producto]

In your case I would be:

If( ShipmentClientDescription=Clientoldname , clientnewname,  ShipmentClientDescription) as ShipmentClientDescription

Regards,

David

[fortaleza40]

And if you use match to have a pattern between old and new name, for example if they keep part of the name as the same or have a code:

if(match(ShipmentClientDescription,clientCommonPattern),clientnewname) AS  ShipmentClientDescription

[Kushal_Chawda]

Would you be able to provide example with sample data?