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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
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?

 

 

 

Asteroid

Hi @RAS-KQ

will your input field always have 3 records ?

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

Asteroid

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