Attached you see a simple table. There are nine “QValue” columns and one “Unique Count” column. I am trying to automatically transfer the appropriate “Unique Count” value to each “QValue Column” when the QValue column contains a “1.0”.
I’m attempting this using the String Manipulation (multi column) node, but I can’t get the regex formula to work. Please denote the precise regex capable of dong this–or tell me there’s a better method than the String Manipulation node.
Thank you for your help