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