Location Move

[New-here1]

Hello,

I need some help with changing a location in the script please.

Company A currently resides in the North but is moving to the West 

I need to show this region change in the script so that when I select Company A, it will show in the West rather than in the North. There are a lot of different company's in the data, many that reside in the North and need to stay showing in the North, so it's just Company A that needs moving from North to West.

I believe an inline table would work here but not sure what the best way to approach it is. 

I hope someone can help.

Thank you

[Or · Accepted solution]

Load SomeField1, SomeField2, Company, if(Company = 'Company A','West',Region) as Region

From YourTable;

A more general solution would be to get the location from a separate table from whatever transactions you're using, e.g.

Load Company, SomeField1, SomeField2 From Transactions

Join

Load Company, CompanyCurrentRegion as Region

From Companies;