Data formatting

[SCK]

Hi all, I need help in formatting the data in Alteryx. I have attached the input and desired file below for your reference. Please see the comma and decimal points.

Input:

190.86
4.85
14.9
200.9
21,000.89
9.000.87
45.090.67
560,000.76
1.560,00.65
3.257.000.45
15.769.056.78

Output:

190.86
4.85
14.9
200.9
21,000.89
9,000.87
45,090.67
560,000.76
1,560,00.65
3,257,000.45
15,769,056.78

[afv2688]

Hello @SCK ,

Would this help?

Regards

[messi007]

@SCK,

Please see below:

Attached the workflow,

Hope this helps,

Regards

[SCK]

Thank you all, the workflows work. However, I came across another situation wherein the numbers after decimal points have increased. Could you help with the below please.

Input:

21,000.898888

9.000.8777777

Output:

21,000.898888

9,000.8777777

[pedrodrfaria]

Hi @SCK 

The WF provided by @afv2688 accomplishes this for you. 

Before:

After:

Is this not what you are looking for?

[SCK]

Apologies, I have one other data set because of which the formula is not working entirely:

 Please help

Input:

190.86
4.85
14.9
200.9
21,000.89
9.000.87
45.090.67
560,000.76
1.560,00.65
3.257.000.45
15.769.056.78
59
47

Output:

190.86
4.85
14.9
200.9
21,000.89
9,000.87
45,090.67
560,000.76
1,560,00.65
3,257,000.45
15,769,056.78
59
47

[messi007]

@SCK,

have you tried the attached workflow?

Regards,

[SCK]

The workflow is partially working because I have cases where the digits after the true decimal points is more than 2. Please help with this.

Input	Output
1,900.000.67777777	1,900,000.67777777
2.547.7679788	2,547.7679788
67.89999999	67.89999999

[afv2688]

Hello @SCK ,

I don't see what the issue seems to be. It works for me

Could you explain us please?

Regards