I am trying to update the table above. What I want to do is if the values in the PMP fields are less than the Max fields update the check fields with PASS, if not FAIL. I started doing this trying to create a list for the PMP fields and a list for the MAX fields and comparing them and updating a check list that I would use to populate the CHECK fields but had issues.
Could this be done using just an Update cursor or numpy somehow?
Here is what I had so far on my list attempt.
pmpValues =  i = 0 for pmpVal in pmpFields: with arcpy.da.SearchCursor(checkTable,pmpFields[i]) as cursor: for row in cursor: pmpValues.append([row]) i += 1 maxValues =  i = 0 for maxVal in maxFields: with arcpy.da.SearchCursor(checkTable,maxFields[i]) as cursor: for row in cursor: maxValues.append([row]) i += 1 checkValues =  for p in pmpValues: for m in maxValues: if p < m: check = "FAIL" else: check = "PASS" checkValues.append(check)