Inter company Customer Company Remap

[#1]

Hi,

More help required.

I have a table that has a Customer No and a Company No see below. However I have a few exceptions where certain Customers have to be remapped to another Company.

For example I need to remap Customer:

HF123

HD123

to Company HS.

Can you advise how this can be done?

Thanks,

Nikki

Company	Customer
HF	HF123
HF	HF456
HP	HP123
HD	HD123
HD	HD456
HS	HS123

[Gysbert_Wassenaar · Accepted solution]

If there are only two values to remap this is easiest:

Load

    if(match(Customer,'HF123','HD123'),'HS',Company) as Company,

    Customer

From ...sourcetable...;