Transpiration happens in daytime. How do you think plants conduct water in night?
During night, transpiration is very low as the stomata closes and the pull created by transpiration is absent to absorb water. In such a situation, root pressure helps to overcome this problem.