How to find min value in different columns

[uacg0009]

Hi all,

Just like the subject, I have data like below:

The result that I want is :

Thanks in advance.
I want to make it in the back-end script, you can use the attachment to be a sample.

Aiolos

[Gysbert_Wassenaar · Accepted solution]

You can use the rangemin function:

LOAD
    ID,
    RangeMin(V1,V2,V3,V4) as MINVALUE
FROM
    ...source data...;

[albert_guito]

I agree with Gysbert, RangeMin is the best solution.

You also can use it as expression in the table

RangeMin(V1,V2,V3,V4)

[uacg0009]

Hi Gysbert,

Really thanks for your reply, I always use rangesum in front-end, it's my first time to use rangemin.

Thanks.
Aiolos