Want to check each numeric column for each row of test and then assign a value (yes or No)Hi,
I want to go through each row in this table for compare value 1 thru value 8, and if one value is less than 1 and any other remaining value is greater than 1, then i say yes or no in the result column. How do i do that?
| ID | value 1 | value 2 | value 3 | value 4 | value 5 | value 6 | value 7 | value 8 | Result |
| 3200110503 | 0.064064 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Yes |
| 3200110520 | 0.057864 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | No |
| 3200110546 | 0.06985 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 3200110562 | 0 | 0.064931 | 0 | 0 | 0 | 0 | 0 | 0 | |
| 3200110597 | 0.06241 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
ScriptingRe: Want to check each numeric column for each row of test and then assign a value (yes or No)In you example data table, all data are less than 1, there are no numeric data greater than 1, so the algorithm you have described could never happen. I assume that either the example data table is in error, or your description of what you are looking for is not correct.
You show that row 1 should result in a Yes, and row 2 in a No, but they are identical in data pattern. All values are less than 1 and no values are greater than 1.
I am sure that I am missing something.Re: Want to check each numeric column for each row of test and then assign a value (yes or No)Hi,
When you are referring to "one value is less than 1" do you mean less than the numerical value = 1 or are you referring to the value of Column 1? Assuming the latter, it is still difficult to grasp the logic behind the results you shared for row 1 and row 2 as @txnelson mentioned
Please, help us help you.
Best,
TS
