Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Combination of calculations based on certain multipliers

jaiiracha
7 - Meteor

Hi All - Struggling to find a way to calculate a value for a record with a variety of different multiplier values. 

My base table is below and I want to calculate the values of each record (Name) in my base table with all combinations of all possible multiplier values. So if the record - "Adam" in my base table has a base value of "1", I want to multiply this value of "1" with all possible combinations of the values for the record "Adam" in all of my multiplier tables. 

Base Table:

NameBase
Adam1
Joe3
Diane4
Jamie2
Sam5

 

Multiplier tables:

NameMultiplier1 - S
Adam1
Joe3
Diane3
Jamie4
Sam2

 

NameMultiplier1 - M
Adam3
Joe2
Diane4
Jamie1
Sam5

 

NameMultiplier1 - L
Adam1
Joe3
Diane3
Jamie3
Sam1

 

NameMultiplier2 - S
Adam5
Joe2
Diane1
Jamie4
Sam6

 

NameMultiplier2 - M
Adam1
Joe4
Diane4
Jamie2
Sam2

 

NameMultiplier2 - L
Adam4
Joe2
Diane2
Jamie5
Sam6

 

Thank you for your support and help with this!! Really appreciate it!

 

 

 

2 REPLIES 2
Qiu
20 - Arcturus
20 - Arcturus

@jaiiracha 
What does your expected output look like?

Raj
14 - Magnetar

without expected output it is not possible to get results , only i can suggest is join the tables

 

Labels