community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

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

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?

 

 

 

Comet

Hi @RAS-KQ

will your input field always have 3 records ?

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

Comet

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

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

Atom

Yes, that's it. Thank you both.

 

I forgot macros can be used like that.

 

D'oh!

Labels