Re: Updating values in a table based on the combination of values in the columns in t
First, before we get too deep into this, I have to say that your structure as you have shown it lacks normalization and resembles something that you could have (and probably did) extract from an Excel spreadsheet. If this is a quick-and-dirty project that is for limited use, what you have might work. If this is part of something much bigger, step away from the keyboard and do some reading on database normalization.
OK, obligatory lesson has been issued. Now to your question:
It is difficult to see what you intend to do because in your post you talk about the columns having some encoded number, but the .PNG shows a text content in a given column. This is difficult to visualize. Further, you have numbers going as high as over 160 in the presentation attachment. Does that imply you actually have that many columns to manage? If not, your use of the columns numbered as you have them and talking about the values in the columns has totally obscured what you are trying to do.
You have given us a technically oriented example of what you want but I know that I can't "see" it in my head. Can you give us an English description of what is going on here? Because all you did was give us substitution rules and without understanding what is being substituted, I know of no particular method except for brute force. Which is the worst and most tedious of methods. With better understanding, I might be able to point you in a better direction.
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.