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
6 - Meteoroid

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