Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Write a Document to SharePoint Library Using the Render Tool

dawnh80
8 - Asteroid

I get questions all the time about Alteryx and SharePoint. I just learned this trick. You can use the Render Tool to write out to a SharePoint Document or Library app.


The trick is to convert your data to a Table in Alteryx using the Table Tool. I have this basic example below and I used the basic settings in the Table Tool when I added it to the workflow.

 
 BasicDataforRender.jpg
 

Next I added the Layout Tool and selected All Records Combined from the Layout Mode drop-down. I left all the other settings as the default.

 
LayoutTool.jpg
 

Then I added the Render Tool with the following configuration;


Output Mode - Choose a Specific Out File

Output File - I put the SharePoint URL and the File name

Data Field - Layout

Separator - No Spacing Between Records

Paper Size - Custom Size

Size - I entered 5 x 7 based on my small data set. You may need to bump this up to 20 X 200 if you have a large data table.

Margins - No Margins

 

RenderToolConfigforSharePoint.jpg

 

My final output appeared as below located in the SharePoint site;

RenderOutput.jpg

2 REPLIES 2
JoaoLeiteV
10 - Fireball

Thanks for the tip! 

 

I've been experimenting with the reporting tools but never tried writing them to SharePoint.

 

Do you know if this would work with the Visual Layout too? I'm using it more than the regular one.

ELPC
8 - Asteroid

In the Render tool, what is the format of the URL and filename?  Do you put the URL and then a space and then the filename?  I'm not understanding that part.  Thanks. 

Labels