Problem with Intersect (knife) - making extra cuts in mesh
Looks like you forgot to move in the face that is used for creating the screw object; you can see that it is moved in slightly in the first GIF of your link, intersecting with the cylinder. If you don't do so, the screw object is on the same face level as the cylinder, which will cause the problem you encountered.