When you hide fields and then create an extract then hidden fields are not extracted and not preserved in the extract files. Also, when you make an extract of a datasource you also "switch" datasource to "point to" extract file and link to your original file is pretty much severed (until you do an extract operation again).
What it means is that fields that you see (with "Show hidden fields") is everything that you have in the extract (everything that's usable). Note that you can hide fields that are in your extract so it's sort of this two-layered thing.
To summarize, in order for you to see fields that you haven't extracted - you need to re-extract them. Agree, flow is a bit confusing but you'll need to do the following:
- Right-click on the datasource and uncheck "Use Extract"
- Now do "Show hidden fields" and unhide everything you need
- Refresh an extract
- Check "Use Extract" back (I don't recall if refreshing an extract will do that automatically)
I don't doubt that your solution might work in some cases, but it doesn't work for me.
It's probably a good idea though to list all the solutions folks can find to this issue, as there might be different causes.
Curious - what exactly does not work for you?
Steps I provided is a proper supported way of doing this.
Are my steps wrong?
"Show hidden fields" does not reveal hidden fields even after unchecking "Use extract".
Would you help me investigate this by your workbook/tde/csv via email (dchirkov at tableau)?
Also, what version are you using?
Sent. I am using the latest version.
Is this supported in 9.1? I am not able to see the "Show hidden fields" option
Wow I was right clicking the datasource