Share via

Scientific anotations in synpase

Dev 1 Reputation point
2022-10-19T15:52:05.173+00:00

Hi,

I want to convert a scientific notation in synapse when i integrate an excel.
Exemple : 47547E+11252086-capture25.png

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,997 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,840 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nandan Hegde 32,416 Reputation points MVP
    2022-10-20T03:03:42.08+00:00

    Hey,
    In the mapping section, you would have to explicitly map the column as decimal :

    252266-image.png

    else it would consider it as string and copy it as E+11

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.