You could do something like this:
SUBSIDIARY as BestSubsidiary
WHERE [SUBSIDIARY RATING]='best';
This would create a separate table. You could also reload the table from itself and just add the new "Best Subsidiary" field to the existing table (by using IF during the load instead of WHERE).
Thank you Vlad for you reply.
I think I'm looking for something different however. To clarify:
The original data showed this:
I created a table showing the rating of the best SUBSIDIARY as follows:
QUESTION: How can I assign the calculated field 'max(SubsidiaryRating)' to the CLIENT. Presumably then I'd also be able to create a chart using the max(SubsididaryRating) field. I hope I explained my question well enough. Thanks in advance!
If I have understood the question correctly, you should be able to use the same expression in the script. Example:
LOAD Client, SubsidiaryRating FROM Datasource;
Client, max(SubsidiaryRating) AS BestSubsidiary
RESIDENT T2 GROUP BY Client;
This will give you a new table with the same content as the chart with Client and max(SubsidiaryRating)