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 | % |
122 | 0,975171 |
122 | 0,024829 |
441 | 1 |
501 | 0,65 |
501 | 0,05 |
501 | 0,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.
key | value | register |
550 | $159.832,00 | A |
122 | $256.367,00 | B |
630 | $105.364.984,00 | C |
441 | $5.698.792,00 | D |
501 | $158.915,00 | E |
505 | $256.304.879,00 | F |
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.
key | value | register |
550 | $155.863,37 | A1 |
550 | $3.968,63 | A2 |
441 | $5.698.792,00 | D |
501 | $103.294,75 | E1 |
501 | $7.945,75 | E2 |
501 | $47.674,50 | E3 |
Could someone help me on this one? If necessary, I can explain the problem once again.
Thanks a lot!
Solved! Go to Solution.
Thanks a lot, @binuacs. Your solution is very useful!