3 Replies Latest reply on Sep 6, 2018 2:30 PM by Anushka A

    Tableau Prep (2018.2.2) discards calculated fields in output step

    Levi Ritchie

      I'm having a lot of trouble getting calculated fields in my extracts, at least for large datasets. Previewing the node before the output gives me what I want, but actually creating an extract vaporizes my calculated fields.

       

      Before:

       

      After:

       

      I'm afraid some details of the data I'm working with is sensitive and under NDA, so I cannot share a packaged flow.

        • 2. Re: Tableau Prep (2018.2.2) discards calculated fields in output step
          Joshua Milligan

          Hi Levi,

           

          It's understandable that having an NDA prevents sharing a packaged flow, but unfortunately there's just not enough detail here to know how to offer a direction.  The design time flow execution can be slightly different than batch-mode (running the flow to output) execution and might result in something different if an order of operations is slightly different.  Have you tried doing the calculation anywhere else in the flow?

           

          If you are still having the issue, please share as much as possible (screenshots, definitely the calculation code, and whatever else you can).

           

          Best Regards,

          Joshua

          • 3. Re: Tableau Prep (2018.2.2) discards calculated fields in output step
            Anushka A

            Hi Levi,

            I second Joshua - we'd need more detail to investigate the issue you are running into.
            Also, a note about the data you see as you build out the flow - it could be that your data is Sampled. You can see that if there's a Sampled badge as below in the profile header:

            Screen Shot 2018-09-06 at 2.27.29 PM.png

             

            That said, when you run the flow in batch-mode to create the output datasource, Prep bundles all the transformations and runs them efficiently against all your data. So the first few rows you are looking at in Prep could be different from the first few rows you see in the datasource you connect to in Desktop.

            Can you verify that the calc isn't being computed correctly for the exact same data row? For instance looking at a particular effort_id and end_time?

             

            Anushka

            Senior Product Manager