1 of 1 people found this helpful
I think I tried the same steps of Edit Value and Ctrl-v (on a PC)
and it seemed to work.
Thank you for checking Swaroop!
I installed Tableau Prep 2018.2.2 to test further, and voila! Working in Tableau Prep v2018.2.2 on the Mac, still not working in v2018.1.2. I was shying away from upgrading prep to 2018.2 as our Tableau Server environment hasn't moved to 2018.2 yet, and I wanted to keep prep and Desktop in sync version-wise. It looks like Tableau Prep v2018.2 has no issue publishing data sources to Tableau Server v2018.1 so moving on to the upgraded version.
Addendum. After upgrading Prep to v2018.2 I had to re-install Desktop v2018.1 as it didn't recognize the Oracle database drivers installed by Tableau Prep.