How to open a door with a clean character animation?

You can either make the animation in your modeling software or use the unreal ik system (https://docs.unrealengine.com/en-US/AnimatingObjects/SkeletalMeshAnimation/IKSetups/index.html).