QV is populating leading '0'

[santharubban]

QV is populating a leading '0' when loading the data from database. In the database there is no leading '0' while pulling into QV leading '0' is populating.

[simondachstr]

It's a formatting issue - try playing around with Text() and Num() while loading in the script, maybe also Trim()

[santharubban]

using Num() its working fine but in some case there is leading '0' in database. In this case i need leading '0' in QV also if i use Num() it is trim the leading '0'.

[MK_QSL]

Try something like below

Load

  Num(VALUE) as VALUE

Inline

[

  VALUE

  07810

  02540

  12354

  00796

];

[Anonymous]

you need an if statement to check if there is a leading zero and format it accordingly, or another way is may be you can look into dual function.

[MK_QSL]

One more

Load

  NUM(RIGHT(VALUE,Len(VALUE)-FindOneOf(VALUE,'123456789')+1),'####0') as NEWVALUE, VALUE as VALUE

Inline

[

  VALUE

  07810

  02540

  12354

  00796

];

[maxgro]

try

text(value)

[simondachstr]

I haven't tried it but what about something like this

If(Text(X)=Num(X),Num(X),Text(X))

[ashfaq_haseeb]

Hi,

Try this

replace(ltrim(replace(yourfield, '0', ' ')), ' ', 0) as NewField

Regards

ASHFAQ