My understanding is that this is due to aliases being embedded in the creation of the view. If you were to reference the same table, but bring it in as a custom SQL query then all of your fields would have the underscore. The table aliases were created when the view was created, so Tableau automatically grabs those aliases on import. If you didn't alias the new fields you created for the view, then they should still have the underscores.
Thank you Wesley!
Thanks, that makes more sense now from your explanation
So going forward it looks like if I add any new columns to the view, it will by default have underscore in it because the table aliases for the new fields were not initially their when the view was created, so I would have to update those fields to not include the underscores
I facing the same issue in one of my dashboard. But I am not using custom SQL as you mentioned above instead I am using the database table. In database the field/ column names are having "underscores" but when I download the full data I am not getting the underscores in my CSV or Excel output instead I am getting "Space" between two words. How to solve this problem?
Thanks & Regards,