1 Reply Latest reply on Nov 18, 2016 5:50 AM by Chris Beck

    Custom SQL fails to pick up existing field from Oracle

    harris.tsr

      Hi All,

       

      This is a very odd situation. I use a custom sql script to pick up several columns from an Oracle table but all of a sudden two of the columns are appeared as hidden and cannot be picked up in Tableau. I've cross checked everything in the Oracle source and the columns do exist, not to mention that the script is being used successfully form more than 2 years. Any ideas how to bring it back to life?

       

      In the screenshot above you can see one of the two broken fields. It's the ***REC_PSR_NAME_C that is hidden..(not sure how it turned to hidden) and not included in the extract.