1 of 1 people found this helpful
Hi Paul -
Are you saving your workbook after refreshing or optimizing your extract?
- You create a new calculated field called "Full Name", which is [First Name] + " " + [Last Name]
- You save the workbook ("I'm safe now", you think)
- You choose Extract | Refresh or Extract | Optimize at some later point
- You close the workbook WITHOUT saving
This pattern of usage would cause a "Calculation_XXXX" field to show up in your workbook instead of "Full Name"
Why, you ask? When you refresh or optimize an extract we (where possible) actually turn your calculated fields into physical fields inside the extract with [First Name] + " " + [Last Name] values saved and pre-calculated. We also "re-map" your old calculated field ("Full Name") to the new column in your extract.
If you close Tableau at this point we'll actually prompt you to save. You might think "yeah, yeah, I saved already" and choose not to. If you don't here's what'll happen:
- There's now's a new field in your extract (calcuation_xxxx) that the workbook has no idea what to do with. The "mapping" information didn't get saved, after all.
- The original "Full Name" calculation doesn't show up either - it was (sort of) deleted and replaced with the new "mapped to the extract column" equivalent which was never saved.
Kind of complicated. Moral of the story - always save after doing anything extract-related. Even if you don't think you've changed the workbook, you have.
I've been doing a lot of data cleaning and still learning how this thing works.
Seems I have to stay in the workbook I started and save everything in there.
I have no idea why Tableau wouldn't save the actual equations when I save my new stuff as a saved datasource.
I'm going to want to adjust those calcs at some point. A lot of my custom calcs are range groupings for age, income, sales price, regions, etc. Just annoying.
I'll try to make sure I keep everything in the same place. Or I might have to edit my back end data extraction to create the values for me, then I can modify the results in my sql scripts when loading in the data. (also not a great option)