Data type Conversion

[Kaish]

Hi all, I am working for a file where the input file has generic numeric values ex - 1E+13 , 1.00017E+13. I want these numbers to be in correct data format, I am using string and Int64 even double datatype but the numbers are not correct. The output numbers are different with many 0's. Kindly guide me through the steps to perform the task. The numbers are ID's and are having more than 15 digits. Kindly help

[Kaish]

Can you create a table out of the data ? as I am unable to add the data in the chat. 

1.00E+13

1.00E+13

2.17E+07

Output

10001713122032

10001713122032

21702603

Can you work now ? I have provided 3 input data, the output is supposed to be as showed in "Output".

[Yoshiro_Fujimori · Accepted solution]

Hi I tried to recreate the issue, but couldn't.

Everythiing looks fine.

Please let me know if I miss anything.

Input 

Workflow

Output (at Output Data Tool)

Output (at Excel)

[Kaish]

Hi @Yoshiro_Fujimori It has been resolved thanks. Actually I had one more problem with another blog where we talked about E-mails, I have new requirements could you please guide me through the steps ? We already discussed and I was able to solve the workflow, kindly let me know if we can do this too https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Sending-Individual-E-mails-to-... .

Thanks @Yoshiro_Fujimori Kindly let me know if we can work on this.