Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Output data into multiple files

Gilld
8 - Asteroid

Hi All, 

 

I am trying to export my data (see attached) into multiple excel files e.g. File name is 1234588968 and file contents as shown below: 

 

Poster_Frame_ID

1234588968

 

Any ideas on the the best way to achieve this please? :) 

 

Thanks!

 

22 REPLIES 22
SorinDiaconescu
6 - Meteoroid

Hi Tom,

 

Let me share the entire picture:) . The xlsx flow works perfect as per the print screen. The CSV one give me this error

Error: Output Data (2): Error creating the file " H:\Group\HR Shared Services\4. Analytics & Insights_202\2018\03. Ad-hoc\ALTERYX\Reg1.cvs||| ": The filename, directory name, or volume label syntax is incorrect.

 

Any help is welcome.

JinoGeorge
7 - Meteor

I have used this logic and worked well for me. Now I need to duplicate 1 excel file into 10 and only of the sheet needs to split based on a field value, other sheets needs to be same in all the files. Any solution? 

cambiukpytou
5 - Atom

I am actually looking for the same thing. Except not by value, just by specific views of the data. Ultimately i am looking for a way the user can select the parameters of the SUM tool.

 

Labels
Top Solution Authors