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.
Would appreciate any and all help with this. Thanks!
Solved! Go to Solution.
@npacheco one way of doing this
Thank! That'll do it.