topic Comparison calculation for price variation check in Talend Studio

Comparison calculation for price variation check

RAJ6 — Thu, 03 Aug 2017 14:52:24 GMT

Hi Talend Folks,

Check the Yesterday Price with Today Price. if today's price is more than 5% of Yesterdays Price then i need to set below values

"Not Ok" else "Ok'

How to write query for above scenario.

I tried but i don't know logic is correct or wrong. could please tell me ?

row1. Today_Price >(row1. Yesterday_Price *0.05)? "Not OK" : "OK"

Re: Comparison calculation for price variation check

Anonymous — Thu, 03 Aug 2017 15:04:36 GMT

The expression looks OK to me. Have you tried it? The only thing I can think that could cause problems is if either "Today_Price" or "Yesterday_Price" is null

Re: Comparison calculation for price variation check

cterenzi — Thu, 03 Aug 2017 21:18:23 GMT

Are you sure the requirement is to check if the price is more than 5% of yesterday's price and not a change of more than 5%?

Re: Comparison calculation for price variation check

RAJ6 — Fri, 04 Aug 2017 05:46:32 GMT

Ya Sure.