CODEWITHSUNDEEP
spotfire
su919
su919

Reputation: 97

How to replace zeros in spotfire without creating new column

I have table as below:

Name       Trans
abc          0.00
zzz          1.22
xyz          0.00
lll          22.31
lal          0.10
ppp          0.00

How can I replace the values 0.00 in the trans column with the value 0.01 without creating new column.

Upvotes: 0

Views: 775

Answers (1)

phiver
phiver

Reputation: 23608

You can use insert transformation => calculate and replace column. You basically replace the original column with a new version where you replaced the values 0.00 with 0.01.

formula you can use: If([Trans] = 0.00, 0.01, [Trans])

Upvotes: 2

Related Questions