Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
Does anyone know how to find the min/max of 4 different fields inside the srcript?
For example:
Load *,
min<- -- number of each sort order comparing these 4 fields
Load
SortOrder
F1,
F2,
F3
F4
from blah
RangeMin(F1,F2,F3,F4) as MinValue
RangeMin(F1,F2,F3,F4) as MinValue