Rohan, can you please describe exactly what you're doing to put a calculated field in the extract file?
This may be a question of terminology but I need to see precisely what steps you are taking from connecting to the root source of data to saving the .hyper extract file.
Thanks for your quick response! I'm taking below steps to create the extract :
- Open Tableau 10.5 and connect to the csv file which is then opened as Live connection.
- Define new calculated fields in a worksheet which i'm able to view when i go back to the Data Source Tab.
- Switch the connection from Live to Extract and still able to view the calculations in Data Source Tab.
- Go back to worksheet and Tableau then asks to save the HYPER extract.
- Unable to find any calculated fields when I open the HYPER extract. However, all other original fields are present and accounted for.
PS : I'm following the exact same steps in Tableau 9.3 to create a TDE extract and able to find calculated fields stored in the extract which is not the case in HYPER.
Hmmm. I wonder if this is a limitation of the Hyper engine in 10.5. You are doing exactly the right things, as far as I can tell.
I literally did this for a client yesterday and it worked just fine. Source was SQL Server but that doesn't matter.
Could you please try it this way and see what happens in 10.5?
1) Connect to the CSV
2) Immediately create the extract and save the workbook.
3) Create your calculated field and save the workbook.
4) Refresh the extract, save the workkbook and close it.
5) Reopen the workbook.
As an alternative to #5, open the .hyper file as a new data source in a brand new workbook.
Let us know what you discover...
Followed the steps mentioned above and still no calculated fields when I open the HYPER file. When I open the workbook I can see the calculated fields still there but somehow Tableau 10.5 is not extracting any calculated fields even after refreshing the extract. I feel like going back to TDE extract but since this extract has to be shared with stakeholders around the world, I reckon many of them will only have Tableau 10.5 and they prefer having a HYPER extract instead of TDE. Thoughts?
Very odd indeed.
Is there any way you could test this with a current version of Desktop?
If you have to fall back to TDE for the moment, that will work. Later versions of Desktop support it just fine.