Opacity output from substance painter does not work properly

You need to view only the alpha channel. Check the image I posted earlier. Untick R,G,B