Configuring Table Format

[Faronnj]

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 

[fmvizcaino · Accepted solution]

Hi @Faronnj ,

Attached is an example showing how to get that done.

LEt me know if that works for you.

Best,

Fernando Vizcaino

[Faronnj]

@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 

[danilang · Accepted solution]

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

[Faronnj]

Thank you both for your help, you both have been very helpful with this research,

Nick