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 |
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 |
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 |
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 |
Hello @SCK ,
I don't see what the issue seems to be. It works for me
Could you explain us please?
Regards
User | Count |
---|---|
107 | |
82 | |
70 | |
54 | |
40 |