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

Multi-Column Formula Shortcut

CorCor
8 - Asteroid

OKay…...

 

Pretty straightforward I think......but can nly solve it the LONG way.

 

Have a dataset (columns B-h) I want to divide by another dataset (columns I-0) (old data vs new data) to get an index. (columns P-V)

Right now - it's all in one table.

Column headings are mostly the same (with exception of old and new designation)

 

I know I can use the formula tool and set up an equation for every comparison - but surely there is a way to do this en masse?

My example attached is just that - my real data has hundreds of columns (thus why I am looking for a shortcut)

 

I COULD divide the table into 2 if that helps anything.....

 

Thanks

Corey

 

 

5 REPLIES 5
TomWelgemoed
12 - Quasar

Hi,

 

Maybe someone has a better way than me, but I always like to use the transpose tool for this type of problem, so to get two columns and then divide column A by column B.

 

I'll look to send you an example shortly.

CharlieS
17 - Castor
17 - Castor

I approach this by transforming the table a bit. The example attached below relies on the field names ("OLD", "NEW", "A/B/C/D....") to make the matches/formulas work. Hopefully this gives you a few ideas to get started.

TomWelgemoed
12 - Quasar

Hi @CorCor and @CharlieS 

 

This is my take on it - I think it can maybe be done with fewer tools. Think @CharlieS 's solution works great too.

 

Solution 13.jpg

CorCor
8 - Asteroid

Thanks

 

this got me thinking!

CorCor
8 - Asteroid

Wow....i like this too.

 

Thank you!

Labels