Discussions

Expand all | Collapse all

Data loss when sorting

  • 1.  Data loss when sorting

    Posted 06-11-2020 12:41
    I have a text field containing a 13 digit number (saved as text).  When I customize the report to group or sort on this number some of the fields are converted to scientific notation.  The source data is coming from an external database and is coming in as a text field. 

    What can I do to preserve all of the numbers in the field?

    PS. it seems odd to me that some records retain all of the digits while others are truncated into scientific notation.

    ------------------------------
    Paul Peterson
    ------------------------------


  • 2.  RE: Data loss when sorting

    Posted 06-11-2020 14:02
    It's impossible that a text field suddenly changes to scientific notation. Text is text is text.   

    It is more likely that the external data coming in via excel is being converted to scientific notation before that corrupted data gets into your app.

    If you can look at how the data is created and can prevent it form being in excel format and retain it in CSV format, that could help.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Data loss when sorting

    Posted 06-11-2020 16:56
    The data is coming in from an Oracle database as text.  It looks like there are more data issues in this table.  It's odd that I am having issues in this table but not other tables that rely on the same data.

    ------------------------------
    Paul Peterson
    ------------------------------