Hi,
Decimal values from source getting as 00000000000000000000.000000(DECIMAL (26,6)).If it's value of integer part and also decimal part is 0(ZERO) then convert it as blank("").
Could you please let me know how to achieve this logic?
Regards,
Srini
Decimal value (00000000000000000000.000000) to blank it
Moderators: chulett, rschirm, roy
Re: Decimal value (00000000000000000000.000000) to blank it
Multiply with 10,00,000 and convert from decimal to integer and check the value is zero. If Yes, populate "" else value.
Re: Decimal value (00000000000000000000.000000) to blank it
1.if value 0000000000000000000.001000 then - final value as 0.001000Satwika wrote:Multiply with 10,00,000 and convert from decimal to integer and check the value is zero. If Yes, populate "" else value.
2.if value 0000000000000001000.000000 then - final value as 1000
3.if value 0000000000000000000.000000 then - final value as ""(blank)
Whatever your suggestion would work out 2 & 3.What about condition 1?
Regards,
Srini
Re: Decimal value (00000000000000000000.000000) to blank it
Even For 1st condition also it works . if you are multipling with 6 zeros then it replaces the decimals and makes it complete integer value. the 1st one's output is 1000. it is greater than 0 . so not required to replace with "".srini.dw wrote:Whatever your suggestion would work out 2 & 3.What about condition 1?
Multplication and all checks do in stage variable and replace blank to the Original column.
-
- Participant
- Posts: 18
- Joined: Tue Dec 25, 2012 10:39 pm
- Location: Detroit,MI
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: