Comma in output instead of dot

[areeba]

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

1. I want to print the column 1  values same(with comma) as input file in the output file
2. I have to apply if else on this column with condition and generate a new column:

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

[atcodedog05 · Accepted solution]

Hi @areeba 

Here is the modified workflow

Output:

Please check and let me know.

[areeba]

@atcodedog05 

Absolutely correct! 😀

Thank you 

[atcodedog05]

Happy to help 🙂 @areeba 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂