Different Combination Challenge!

[Chadiom]

Hello, I would like to request help in the below challenge.

I have a table as per the below:

1	A	10
2	B	20
3	C	53
4	D	65

In another table i have the below:

A, C

B, A, D

C, C, C

D, A, D, D, A

.... endless possible combinations

I need to find the average score for the different possible combinations of letters, is possible to do it through alteryx?

Do you recommend a specific approach ? 

The table above is just a small example of the challenge, the table is bigger and so combinations are numerous.

Thank you!

[markcurry]

Hopefully this workflow helps, I'm not fully sure what you are trying to do.

[danilang · Accepted solution]

Hi @Chadiom 

Here's a way you can do it.

Split the combos to end up with one letter per row.  Join this to Letter Value table on Letter.  Then you can summarize to give you that value of each combo.  I added them, but you can perform any operation you require.

 

Dan