Floating data type

Avatar

Avatar

sourabhk1148999

Avatar

sourabhk1148999

sourabhk1148999

28-08-2019

Hi Team,

Is there any way to take any floating type data up to 4 decimal digital place and load to schema with help of data Loading Activity.Whenever I am taking the floating datatype in declaring column details in data loading activity it will trucnate the alst 2 decimal digits also tried same with  double precision.

Sample data is 13456567.2363.

Regards,

Sourabh

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

wodnicki

MVP

Avatar

wodnicki

MVP

wodnicki
MVP

05-09-2019

Hi,

The console UI will only display 2 digits precision, though the data will be same as ingested.

E.g. @col > 1 will return values 1.0001.

UI will also display null number values as 0, among other quirks.

Thanks,

-Jon

Answers (1)

Answers (1)

Avatar

Avatar

sourabhk1148999

Avatar

sourabhk1148999

sourabhk1148999

06-09-2019

Thanks wodnicki