Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Export pivot view to Spreadsheets via a chain

Answered
Request Demo

I followed the Export pivot view to Spreadsheets via a chain receipt, but at final step "overwrite Sheet data command", i'm getting data output from the query, not the expected data output form the downloaded pivot.

0

Comments

1 comment

Date Votes
  • Jeff Hickey

    Hello Inessa,

    Views are constructed based on the query result that is feeding it. Views run a query and also grabs additional metadata information such as the query result ID. You can retrieve this metadata using the Get Pivot View command. Views are a frontend construct and therefore their results cannot be downloaded. This means that Download Pivot View command is retrieving the underlying query results flat file that is used to build the pivot view.

    0

Please sign in to leave a comment.