Numerics

[nareshthavidishetty]

Hi,

I have created  a table in that i am facing a problem below image is the reference.

How to convert this into numeric.

[tamilarasu]

Hi,

Then try,

Num( Evaluate([Device Id]),'##.#') as [Device_ID]

[Anonymous]

how data type can be different when you are loading from a table?

Are you having multiple tables with same field and different data types??

[qlikviewwizard]

Hi Naresh,

What is your required output?

[vipin_mishra479]

Hi,

Try to evaluate() function for this

may be this will help

vipin

[nareshthavidishetty]

not working

[tamilarasu]

Did you try the below one,

Num( Evaluate([Device Id]),'##.#') as [Device_ID]

[jonathandienst]

>>Still i am getting the same out result after using the below field

>>Text([Device Id]) as [Device_ID],

This must be the first load from the data source, which should have the number in normal number or text format without the exponent.

[nareshthavidishetty]

please go through with the below image,i need to show Like some ID's consists of numeric and some Id's consists of text

[Chanty4u]

use only

num(fieldname)

[Chanty4u]

Num(NUM#([device], '#'),'#.000') AS [deviceid]