Floating data type

[sourabhk1148999]

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

[Jonathon_wodnicki · Accepted solution]

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

[sourabhk1148999]

Thanks wodnicki​