Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Insert value from different input with same name multiple times

npacheco
6 - Meteoroid

Hi folks, looking for some help on this one.

I have ~4000 companies with ID's and each of them has a number of "Criteria" with a 0, 1, or NULL value. The criteria have their own ID's: (E01, E02, etc).

 

I have a separate file that contains "weights" for each of these criteria. A numeric value between 0 and 10.

 

For each "1" found in each Criteria of each company, I need to replace it with the relevant weight of that criteria. 

It's a little difficult to explain so hopefully the attached demo file with expected output will help.

Screenshot 2025-03-24 125554.png

Would appreciate any and all help with this. Thanks!

2 REPLIES 2
binuacs
21 - Polaris

@npacheco one way of doing this

image.png

npacheco
6 - Meteoroid

Thank! That'll do it. 

Labels
Top Solution Authors