Hello all,
I have an issue where I have to rename some customers based on some silly historic changes that were overwritten. In Power Query, I'd like to do the following:
1) Check two columns for a specific customer name and a specific location.
2) Based on criteria in both, change the customer name.
So for example:
I may have:
Customer Name | Location
---------------------------------
Acme Corp | Pittsburgh
Acme Corp | Cleveland
Acme Corp | New York
But Cleveland is no longer owned by Acme Corp, so I'd want to just change it for all time to make it simple JUST for that customer/location combo:
Customer Name | Location
---------------------------------
Acme Corp | Pittsburgh
Jones Corp | Cleveland
Acme Corp | New York
Any advice here? I thought about somehow tagging the columns with a TRUE or a number based on the combo, but I still don't know how to operate across two columns. Thanks for your advice.
I have an issue where I have to rename some customers based on some silly historic changes that were overwritten. In Power Query, I'd like to do the following:
1) Check two columns for a specific customer name and a specific location.
2) Based on criteria in both, change the customer name.
So for example:
I may have:
Customer Name | Location
---------------------------------
Acme Corp | Pittsburgh
Acme Corp | Cleveland
Acme Corp | New York
But Cleveland is no longer owned by Acme Corp, so I'd want to just change it for all time to make it simple JUST for that customer/location combo:
Customer Name | Location
---------------------------------
Acme Corp | Pittsburgh
Jones Corp | Cleveland
Acme Corp | New York
Any advice here? I thought about somehow tagging the columns with a TRUE or a number based on the combo, but I still don't know how to operate across two columns. Thanks for your advice.