How to round the price value in data?

[Anonymous]

Hi Team,

I have a data like this with a column MYR , I need them to give a round value, For Ex: 625509.34 means required output 625510

Source Data type is Double , destination anything you want or same ? Empty records should be replaced with 0 as well.

Thanks & Regards,

Prabhakaran

[bhagyarekha · Accepted solution]

Hi 

input string output double

in tmap  expression builder write down

row1.price!=null?Double.parseDouble(row1.price):0

in output tmap

Math.ceil(Var.var1)

Regards

rekha