In Talend how to specify multiple conditions as expression

Question

hi,

I'm working on talend7.2. I am creating a map using Tmap. I need to specify the following expression JOIN and condition.

((ITM_MAS_SUMMARY_ROW.ITMRATE>=SALES_RANGES_DIM_ROW.FROMRATE) && (ITM_MAS_SUMMARY_ROW.ITMRATE<=SALES_RANGES_DIM_ROW.TORATE)) && (ITM_MAS_SUMMARY_ROW.PRDCODE==SALES_RANGES_DIM_ROW.PRDCODE) .

But when i run the job, it throws an error message. (The message shows error at >=).

Please help me solve this situation.

Comments

Hi Palani, can you please share the screenshot of the error?? That will be really helpful.

---

What is the data type of the fields that you are comparing?

---

ITMRATE is Number (Bigdecimal in Talend)

FROMRATE & TORATE  are Number (Both are Bigdecimal in Talend)

and PRDCODE is string.

---

Try using .compareTo() function instead of direct comparison like below.
ITM_MAS_SUMMARY_ROW.ITMRATE.compareTo(SALES_RANGES_DIM_ROW.FROMRATE) [ > / < /  == ] [Value]

Here value is 0 if Equal,

value = 1, if fromrate > itmrate else -1.

---

Hi there.

The compareTo is not working for me. Can anyone suggest me another way of solving this.

((ITM_MAS_SUMMARY_ROW.ITMRATE>=SALES_RANGES_DIM_ROW.FROMRATE) && (ITM_MAS_SUMMARY_ROW.ITMRATE<=SALES_RANGES_DIM_ROW.TORATE)) && (ITM_MAS_SUMMARY_ROW.PRDCODE==SALES_RANGES_DIM_ROW.PRDCODE) .
Here the ITMRATE shoule be BETWEEN FROMRATE and TORATE.

Thanks in advance.

Answer 1

@Palaniswamy, have a look at this discussion from Talend Community.

Hope this will help!

Join the Talend course today to know more about and become expert.

Thanks.