Hi, i'm looking to compare the ClusterNameFinal and replace the Compliance Score Final that has the lower score with the highest score that has the same ClusterNameFinal.
So the end result would look something like this:
In it's simplest form you can use this expression as a Measure:
Max(TOTAL <ClusterNameFinal> [Compliance Score Final])
The assumption is that the combination of HostNameFinal and ClusterNameFinal only have a single row of data.
hi, thanks for suggesting a solution, but how can this be done in the data load editor instead?
This is how it can be done in a load script:
and lines from 20 to 29 can of course be replaced with a LOAD ... FROM or LOAD ...; SQL SELECT ...
Retrieving data ...