Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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;
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;