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 * I want to print the column 1 values same(with comma) as input file in the output file * 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

Comma in output instead of dot

areeba

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

I want to print the column 1 values same(with comma) as input file in the output file
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

Output

Accepted answers

atcodedog05

Hi @areeba

Here is the modified workflow

Output:

Please check and let me know.

digits.yxmd

All comments

philipmannering

Hi @areeba

I think this does what you want,

I change the float to a string with commas and at the right dp. See attached.

Thanks,

Phil

fullstop to comma.yxmd

areeba

Hi @PhilipMannering

Thank you for the solution it is exactly i have been looking for.

There are two things

1) if value is 1 or greater than 1 for eg here its 1.1111 then also it should also print 1,00 .As for now it is just showing 1 in output.

for eg:

Column1 Output

1 1,00

1.1111 1,00

2) Also , like i mentioned as per my requirement i need to show Column1 also in my output with Comma not the Dot. Originally it is a comma in the source file but when i am loading the source file that comma becomes a dot.