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!
Solved! Go to 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.
Thanks for the solution. Yes, that was a mistake.