How to stop Datameer from converting excel Text to Scientific Notation

2 followers
0
Avatar

Does anyone have a good suggestion for this? I have a column in Excel with values like 9HY as well as 100798325. I need them as strings but Datameer converts the large numbers to 1.00798325E8 which causes an expression to break later in the process.

I've tried changing the column type in Excel to Text with no luck. Please let me know.

Thanks,

Dom

Bardele, Dominic

2 comments

  • Avatar
    Konsta Danyliuk

    Hello Dominic.

    You could to try to save the excel sheet with large numbers as csv file (double check that there is no values in scientific notation in this csv) and import this file into Datameer. If you need these values as strings, choose the type of the column as STRING in Datameer ImportJob wizard.

    0
    Comment actions Permalink
Please sign in to leave a comment.