Update formula dynamically based on inputs

Question

Hi,

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

Input 1:

NameClassCodeX10AAAX10AA1X10AA2X10AB1X10AB2Y11AAAY11AA4Y11AX4Y11CC1

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

Input 2:

NameClassAAAAA1AA2AB1AB2AA4AX4BBBCCCCC1DD2X10AAA1AA11AA2XAB11AB22AA4QAX41BBB1CCC1CC11DD2AY11AAA2AA1BAA2YAB12AB23AA4XAX42BBB2CCC1CC1A

Formula:

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

Output:

NameClassoutputX10AAA1-AA11-AA2X-AB11-AB22Y11AAA2-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!

MichaelLaRose · Accepted Answer

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.