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
Solved! Go to Solution.
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".
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.