writing multiple excel files to sharepoint

Question

Hi all,

i have a workflow that generates the output. Now, i want to create several views (one view with all column, other with 2 column, another with 3 column etc.), and want to write these files to SharePoint.

my solution for now is that, i am using multiple SharePoint output tool for each view. is there any efficient way to write these, so that Alteryx doesn't authenticate again and again.

abacon · Answer

@Alter_Shivi Another option is to do the batch macro but with a regular output data tool mapped to the sharepoint location. If this is running on Gallery, you can give the server machine access to the sharepoint site and ensure you have the correct file path. This will eliminate the authentication time in the sharepoint outpoint tool.

Bacon

Alter_Shivi · Answer

@Gaurav_Dhama_ but this will still have sign in's for each file, making high execution time. right?

Gaurav_Dhama_ · Answer

As long as everything goes to the same location in SharePoint, you can put SharePoint output tool inside a batch macro and output the data, as many times as you need.