topic Find whether a value is between two numbers in Talend Studio

Find whether a value is between two numbers

JM39 — Fri, 15 Nov 2024 23:10:58 GMT

Hello

I imagine this is quite simple but I'm struggling to find the answer. Essentially I'm trying to find a 'between' function. So I want to say:

If row1.MY_COLUMN is between 500000 and 610000 then use that value, else 'something else'..

Tia for any help!

Re: Find whether a value is between two numbers

Anonymous — Wed, 23 Feb 2022 15:44:00 GMT

row1.MYCOLUMN >=500000 && row1.MYCOLUMN <=610000 ? row1.MYCOLUMN : -1

This is an in-line IF. It says, "IF MYCOLUMN is greater than or equal to 500000 and MYCOLUMN is less than or equal to 610000, then use MYCOLUMN, else use -1".

Re: Find whether a value is between two numbers

JM39 — Wed, 23 Feb 2022 16:13:15 GMT

Works perfectly, thank you! 🙂