Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

How to solve this problem

jpscoralick
8 - Asteroid

Hello everyone!


As a Alteryx newbie, I'm facing some challenges here. I know how to solve the problem below with other languages, but I can't see how to solve it with Alteryx.

I have a 2 Excel files as input. The first is the one below. For each key, summing the corresponding "%" column we have 100%.

key%
1220,975171
1220,024829
4411
5010,65
5010,05
5010,3

 

The second input has the same keys and others. So, I have to find on it all the keys from the first input and multiply each one for its percentage.

keyvalueregister
550$159.832,00A
122$256.367,00B
630$105.364.984,00C
441$5.698.792,00D
501$158.915,00E
505$256.304.879,00F


For example, the key "122" has two percentages 0,97517 and 0,02483 on the first file. So, on the second one, I have to multiply its value $ 159.832,00 for 0,97517 and 0,02483, generating two new rows, as can be seen below. And each row has its own register value, so: A1 and A2, once the value is A on the second file.
For the key "441", it is only one row, once its percentage is 100%. For "501" key, we have 3 rows regarding each percentage.

keyvalueregister
550$155.863,37A1
550$3.968,63A2
441$5.698.792,00D
501$103.294,75E1
501$7.945,75E2
501$47.674,50E3

 

Could someone help me on this one? If necessary, I can explain the problem once again.

Thanks a lot!

2 REPLIES 2
binuacs
21 - Polaris

@jpscoralick One way of doing this

binuacs_0-1682007786906.png

 

jpscoralick
8 - Asteroid

Thanks a lot, @binuacs. Your solution is very useful!

Labels