mercredi 26 octobre 2016

Talend-Convert IF-THEN ELSE into Tenery operator

We are trying to turn IF-THEN-ELSE statement of tableau Reporting/BI tool INTO TERNERY OPERATOR Java Based Talend tool Or JAVA based IF-THEN-ELSE

Input Data

if isnull([Ship Date (Calculated)]) then
(if (attr(trim([Corp Acct Name])) = 'ABC' 
or attr(trim([Corp Acct Name])) ='BCD' 
or attr(trim([Corp Acct Name])) ='CDE') 
then 
(if DATEPART('weekday',ATTR([ ShipDate])) =1 then (attr([ ShipDate])-3)
elseif DATEPART('weekday',ATTR([ ShipDate])) =2 then (attr([ ShipDate])-3)
else  (attr([ShipDate])-2) END
) else (if DATEPART('weekday',ATTR([ ShipDate])) =1 then (attr([ ShipDate])-2)
else  (attr([ ShipDate])-1) END
) end)
ELSE
(if (attr(trim([Corp Acct Name])) = 'ABC' 
or attr(trim([Corp Acct Name])) ='BCD' 
or attr(trim([Corp Acct Name])) ='CDE') 
then 
(if DATEPART('weekday',[Ship Date (Calculated)])=1 then ([Ship Date (Calculated)]-3)
elseif DATEPART('weekday',[Ship Date (Calculated)])=2 then ([Ship Date (Calculated)]-3)
else ([Ship Date (Calculated)]-2) end)
 else (if DATEPART('weekday',[Ship Date (Calculated)])=1 then ([Ship Date (Calculated)]-2)
else ([Ship Date (Calculated)]-1) end) end)
END

Output Data:

Looking for ternery Operator based on JAVA.

condition1?(condition2?value if true:value if false): (condition3?value if true:value if false)

Thanks for valuable time !

Aucun commentaire:

Enregistrer un commentaire