Goodafternoon Alteryx Community,
I have a simple table formatting question, this is what my data looks like following all my formulas:
Spherical Regression (D/year) | Outcomes |
12-24mo [Mean +/- StdDev] | 0.06 +/- 0.7 |
12-24mo [Max to Min] | -1.67 to 2 |
24-36mo [Mean +/- StdDev] | -0.12 +/- 0.38 |
24-36mo [Max to Min] | -1.1 to 0.7 |
36-60mo [Mean +/- StdDev] | -0.08 +/- 0.25 |
36-60mo [Max to Min] | -0.62 to 0.5 |
60-84mo [Mean +/- StdDev] | -0.02 +/- 0.18 |
60-84mo [Max to Min] | -0.46 to 0.25 |
84-108mo [Mean +/- StdDev] | -0.04 +/- 0.18 |
84-108mo [Max to Min] | -0.31 to 0.19 |
>108mo [Mean +/- StdDev] | -0.25 +/- 0 |
>108mo [Max to Min] | -0.25 to -0.25 |
Last Follow-Up [Mean +/- StdDev] | 0.02 +/- 0.48 |
Last Follow-Up [Max to Min] | -0.94 to 3 |
I would like this table to be converted into the following format and am lost on where to go from here:
Spherical Regression (D/year) | Mean +/- StdDev | Max to Min |
12-24mo | 0.06 +/- 0.7 | -1.67 to 2 |
24-36mo | -0.12 +/- 0.38 | -1.1 to 0.7 |
36-60mo | -0.08 +/- 0.25 | -0.62 to 0.5 |
60-84mo | -0.02 +/- 0.18 | -0.46 to 0.25 |
84-108mo | -0.04 +/- 0.18 | -0.31 to 0.19 |
>108mo | -0.25 +/- 0 | -0.25 to -0.25 |
Last Follow-Up | 0.02 +/- 0.48 | -0.94 to 3 |
I understand it is probably a simple fix with some tools but I am completely lost, if you wouldnt mind providing your workspace I would greatly appreciate it for a reference and really helps me learn this program. Thank you in advance for all your help and look forward to hearing from you,
Nick
Solved! Go to Solution.
Hi @Faronnj ,
Attached is an example showing how to get that done.
LEt me know if that works for you.
Best,
Fernando Vizcaino
@fmvizcaino Hey Fernando always appreciate your help and quick replies. Your workspace worked perfectly but when I attach and implement it into mine, I cant figure out why after the formula - the "]" gets removed which I think is where the error icomes in reformating the table. How would I fix this or fix the formula?
Thank you for all your help over the weeks,
Nick
Hi @Faronnj
The input tool uses the max string length(32) as the length for the field. Since you're adding the "|" character your longest string ends up 33 characters long, so the last "]" gets chopped off. Add a select and increase the field length to 100 before your formula
Dan
Thank you both for your help, you both have been very helpful with this research,
Nick