Floating data type | Community
Skip to main content
S
Sourabh_T
Level 2
August 29, 2019
Solved

Floating data type

  • August 29, 2019
  • 2 replies
  • 3531 views

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

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Jonathon_wodnicki

    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

    2 replies

    Jonathon_wodnicki
    Community Advisor
    Jonathon_wodnickiCommunity AdvisorAccepted solution
    Community Advisor
    September 5, 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

      S
      Sourabh_TAuthor
      Level 2
      September 6, 2019

      Thanks wodnicki​

      Terms & ConditionsAccessibility statement

      Loading footer...