Following the Add Join geoprocessing tool, the Feature Class to Feature Class tool creates a feature class with the correct number of rows based on Keep All Target Features being unchecked; however, all values within the feature class are <Null>.
The Add Join output layer created prior to the Feature Class to Feature Class tool has Add To Display checked and upon review contains the correct number of rows and the values are populated.
I end up running the Feature Class to Feature Class tool manually from the Analysis tab and it is successful albeit with warnings. Not sure if that might be the issue.
My desire is to not run this tool manually, your assistance would be greatly appreciated.