Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Text to column in a formula, 1+2+1 (sum)

RAS-KQ
5 - Atom

Hello,

 

I'm stuck at a problem, can't figure it out...

 

I have a list of values seperated with a string (result from a cross tab), looks like this:

Cross Tab.JPG

 

 

I would like to sum the values in the input column using a formula.

 

There are 20 more columns like this, so probably a multi field formula, but how?

 

 

 

4 REPLIES 4
Aidan_K
11 - Bolide

Hi @RAS-KQ

will your input field always have 3 records ?

i.e. 3 numbers = 0+0+1

Aidan_K
11 - Bolide

assuming the answer to previous question is yes you could parse the data (using + as delimiter), add new fields together and finally select the fields you want to keep (i.e. "Input" & "Output")

See example attached

jdunkerley79
ACE Emeritus
ACE Emeritus

If you want to create a workflow which can decode any formula then you can do this using a batch macro.

2018-10-15_14-06-05.png

 

The attached creates a simple evaluation of each row.

 

There is a more fully featured macro included in the CReW macros

RAS-KQ
5 - Atom

Yes, that's it. Thank you both.

 

I forgot macros can be used like that.

 

D'oh!

Labels