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

Update formula dynamically based on inputs

hash_89
8 - Asteroid

Hi,

 

I need the formula tool to be update dynamically based on inputs.

 

Input 1:

NameClassCode
X10AAA
X10AA1
X10AA2
X10AB1
X10AB2
Y11AAA
Y11AA4
Y11AX4
Y11CC1

Inputs from this needs to be used to do some transformation with another input

 

Input 2:

NameClassAAAAA1AA2AB1AB2AA4AX4BBBCCCCC1DD2
X10AAA1AA11AA2XAB11AB22AA4QAX41BBB1CCC1CC11DD2A
Y11AAA2AA1BAA2YAB12AB23AA4XAX42BBB2CCC1CC1A 

 

Formula:

For Name & Class, the values in 'Code' Column should be concatenated and separated by '-' for input 2

 

Output:

NameClassoutput
X10AAA1-AA11-AA2X-AB11-AB22
Y11AAA2-AA4X-AX42-BBB2

 

I'm using Alteryx 2018.3 version and i cannot see crew macros to see how to go about it.

 

Can someone please help on this? This is a large data set and the fields are very dynamic.

 

Thanks!

2 REPLIES 2
MichaelLaRose
10 - Fireball

Hi @hash_89 ,

 

I am able to almost replicate your desired output, however, your Y-11 output has BBB2 as the final element, but your Input 1 lists CC1 instead of  BBB. Is this intentional?

 

I ended up using the Summarize tool instead of the creating a formula because it is much easier to do there.

 

Let me know if I interpreted your goal correctly.

 

Best,

Michael

 

P.S. Nothing I did should be version specific so you should be able to open the file in an older version of Alteryx Designer. There will be a pop-up with a warning. 

hash_89
8 - Asteroid

Thanks for the solution. Yes, that was a mistake. 

Labels