azure data factory excel files (new feature)

CORONADO GRANADOS Diana Milena 126 Reputation points
2020-07-16T14:24:53.59+00:00

Hello
I'm creating a pipeline that uses an Input file an excel, when I create the dataset looks fine but when I've try to execute some actions to the number colums they put a strange format.

The columns on the originalexcel looks like

12761-image.png

But in the azure data factory I have (i donot want that 5003740**.0**)

12752-image.png

what can I Do?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,517 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HimanshuSinha-msft 19,471 Reputation points Microsoft Employee
    2020-07-17T21:00:54.403+00:00

    Hello ,
    Thanks for the question & welcome to the Q&A .

    Let me start with that I am not sure as to how you are getting the * in 5003740*.0* , but then i tried to repro the issue , I did created the below data in a worksheet

    I see that you are using a dataflow , i just used the derived column option and used the function ToInteger() to make the thing work . The below screenshot help you understand the implementation . Please do let me knom if you need any furrther help .

    12790-1.gif

    Thanks & stay safe

    Himanshu

    Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

    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.