ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

Alteryx Server Knowledge Base

Definitive answers from Server experts.

The Gallery: Composer File Type for Multiple Output Options

TonyM
Alteryx
Alteryx
Created

The Composer File (pcxml) is a file type that contains a proprietary language used by Alteryx for reporting purposes. What this means for use in the Gallery is that an end user will have the ability to choose among XLSX, PDF, DOCX, ZIP and HTML file types for output.

 

composer 1.png 

 

In order to use the pcxml format, you will need to use the Render tool, which can be found in the Reporting section of the tool palette. A basic Table tool connected to the Render tool will suffice for a grid report, shown respectively.

 

 composer 2.png     composer 3.png

 

 

The configuration for the Render tool will require two things, first, that the Output Mode is set to choose a Specific Output File. The Gallery validation of the workflow will fail in the Public Gallery unless a specific output is set. Next, select the pcxml file type for output and name the file. Upon loading the workflow to the Gallery you’ll see that the dependency changes to an externals path “_externals\1\name.pcxml”, this is expected. The second configuration property to set is the Data Field in the Report Data section. We will need to reference the table created using the basic Table tool.

 

composer 4.png

 

Now load the workflow to the Gallery and that’s it! Enjoy the flexibility of reporting file formats the pcxml Composer file has to offer!

 

Note: Workflow and all images created in this article are from Alteryx version 10.1

 

Tony Moses

Client Services Representative

Comments
Coxta45
11 - Bolide

This is so cool!  I just changed the output on one of my apps in our gallery to use this feature as opposed to always outputting an excel file.   I love seeing the preview of the results in the window after the app runs. 

 

PCXML.JPG

 

Thanks!

 

Taylor

 

 

minhdvo
5 - Atom

It is a good solution. I can give different output files and also display the output results on the screen when running the app in the server.

 

Thanks.