We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

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

Split rows into different sheets

beatrizmguerreiro
8 - Asteroid

Hello, 

 

I have the following dataset:

StatusActivityUser ID
NewActivity 11234
In ProgressActivity 25678
In ProgressActivity 390123
CompletedActivity 490123

 

Based on the "Status" , is it possible to split the rows into different sheets, in an excel output?

- Keep table structure  

- Rename sheets with Status' name.

 

Expected end result:

 

Sheet 1: rename to "New"

StatusActivityUser ID
NewActivity 11234

 

Sheet 2 : rename to "In Progress"

StatusActivityUser ID
In ProgressActivity 25678
In ProgressActivity 390123

 

Sheet 3: rename to "Complete"

StatusActivityUser ID
CompletedActivity 490123

 

Thank you in advance.

10 REPLIES 10
AngelosPachis
16 - Nebula

Hi @beatrizmguerreiro ,

 

Yes that's doable. In your Output Data tool, check the box at the end of the configuration window, and from the dropdown select to change the file/table name based on the field "Status"

 

AngelosPachis_0-1610114343294.png

 

You shall get an output with a different sheet for each status

 

AngelosPachis_1-1610114372088.png

 

Hope that helps.

 

Regards,

 

Angelos

marcusblackhill
12 - Quasar
12 - Quasar

Hey @beatrizmguerreiro !

 

In your output data you need to configurate like that:

marcusmontenegro_0-1610114352745.png

Select one place to save the output like excel, with 1 sheet name like example and in the bottom of the tool, check the option "Take file/table" and in dropdown select the field you want to use like guide to split.

 

Hope that help!

AngelosPachis
16 - Nebula

@beatrizmguerreiro 

 

as a small note, make sure you change option 3 from create new sheet to either overwrite sheet or overwrite file to prevent your workflow from getting an error

 

AngelosPachis_0-1610114738809.png

 

beatrizmguerreiro
8 - Asteroid

Hello Angelos, 

 

I can't make it work. I configured as you said and it's not working 😕 

 

I didn't mentioned in the first question that I am dealing with a large of volume of rows, so I have to split this large file into multiple files with 100 rows each. Might that be the reason? 

AngelosPachis
16 - Nebula

Yes @beatrizmguerreiro ,

 

I really apologise for that, it's my mistake that I didn't test the workflow before sending the screenshot.

 

If you have set this to overwrite file, do you mind changing that to overwrite sheet or range?

 

AngelosPachis_0-1610115221621.png

 

The issue with selecting overwrite a file is that each time alteryx creates a tab, it will bin the old file, hence all the other sheets. So you will end up with a single sheet in your output, the last one in that sheet sequence.

 

If you change that to overwrite sheet however, alteryx will only replace the corresponding sheet.

 

I reckon that's the problem you faced?

beatrizmguerreiro
8 - Asteroid

Yes, perfect. 

 

Thank you all very much

MichaelBouley
7 - Meteor

super helpful, thank you!

Sanjana_HS
8 - Asteroid

Hi,

In this the status is coming in 1 excel but different tabs what if i want those tabs in different excel sheet

cwilcoxmtn
7 - Meteor

This was a perfect answer for my search.  Thank you!

Labels