Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Don't forget to submit your entry for the Excellence Awards by October 30! | Need more information about the program? Check out the blog here
SOLVED

Update formula dynamically based on inputs

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!

Highlighted
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. 

Highlighted
8 - Asteroid

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

Labels