Hi
In my source file one column is defined like this
Input:
Column1
1,111
0,8889
0,75
please note :its a comma in between not the dot in source input
When i am reading this in Alteryx the datatype is Double and this comma changes to dot . So it becomes like this
Column1
1.111
0.8889
0.75
My requirement is
IF column1 is greater than or equal to 1 then it round up to 1
For eg: 1,111 will become 1,00
Similarly if column1 is less than or equal to 0 then it should print this way
0,75 will become 0,75
0,8889 will become 0,89
Can you please suggest the solution
Regards
Areeba
Solved! Go to Solution.
Happy to help 🙂 @areeba
Cheers and Happy Analyzing 😀
Feel free to reach out if you face any issues 🙂