Update formula dynamically based on inputs

[hash_89]

Hi,

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

Input 1:

Name	Class	Code
X	10	AAA
X	10	AA1
X	10	AA2
X	10	AB1
X	10	AB2
Y	11	AAA
Y	11	AA4
Y	11	AX4
Y	11	CC1

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

Input 2:

Name

Class

AAA

AA1

AA2

AB1

AB2

AA4

AX4

BBB

CCC

CC1

DD2

X

10

AAA1

AA11

AA2X

AB11

AB22

AA4Q

AX41

BBB1

CCC1

CC11

DD2A

Y

11

AAA2

AA1B

AA2Y

AB12

AB23

AA4X

AX42

BBB2

CCC1

CC1A

Formula:

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

Output:

Name	Class	output
X	10	AAA1-AA11-AA2X-AB11-AB22
Y	11	AAA2-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 solution]

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]

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