azure data factory excel files (new feature)

Question

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

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

what can I Do?

Answer 1

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 .

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