Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

output the data in two different files as .xslx or .csv

Venkatesh23
7 - Meteor

Hello guys,

 

I have data where it consists of companies details. Where it has 2 company data in a single file. But, I need to separate files outputs as 2 different companies (whether the output file can be .xlsx or .csv).

I was successful when I tried to output .csv.

 

But the problem was not able to add the file output name in the top of the output file then the following data. As shown in the below Image.

clipboard_image_0.png

Image refers output file of comCode=1(OutputFile1)

If possible can share the ideas or sample workflow.

 

I have attached the sample file of Input data and required output file 1&2.

The output can be .xlsx or .csv format. whichever is possible.

 

Thanks in Advance.

Venkatesh

 

2 REPLIES 2
RolandSchubert
16 - Nebula
16 - Nebula

Hi @Venkatesh23 ,

 

what about using the reporting tools? Create the tables using the "group by" option, add the report header to the tables and write it to Excel files using the Render tool. Find attached a sample workflow. Hope this is helpful.

 

Best regards

 

Roland 

Venkatesh23
7 - Meteor

Thanks, @RolandSchubert for your quick response.

 

The solution works great for me.

 

Thanks

Venkatesh

Labels