It's a bit convoluted, but I think this can be addressed in Tableau Prep.
Shown below are the joins, basically needed two separate joins to the Company Info.
Then at the end, did some consolidation such as if one of the App IDs was null then use the one
from the other join:
IFNULL([App ID a1], [App ID c2])
Because I had so many versions of the fields floating around, I renamed them in Prep.
Attached in the Forum Thread are is tflx v18.3, the tde, and the twbx v10.3:
Thank you! This is probably the best solution within Tableau (obviously ideally the data wouldn't be set up this way).