Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Output - Different tabs - Same file

Sarath27
8 - Asteroid
 

Hi All,

 

I have been struggling to achieve this output in many ways using render tool, but output doesn't come out well.

 

Please kindly assist me in achieving this, refer the attached workflow. 

14 REPLIES 14
ChrisWaspe
9 - Comet

Hi @Sarath27 . Please provide a packaged workflow (Options -> Export). This will include you data in the workflow. When Rendering data to different excel sheets, you need to change the Separator option to 'Insert Section Breaks Between Records' and pick the appropriate grouping field.

Sarath27
8 - Asteroid

Ho @ChrisWaspe Pls find the attached package and help me out.

Sarath27
8 - Asteroid

Any work around for this please?

binuacs
21 - Polaris

@Sarath27 One way of doing this

image.png

Sarath27
8 - Asteroid

@binuacs I tried this already, but whenever I open this file its shows repaired and needs to be recovered and also column names are getting shrinked when expand.

 

Is there any work around with exporting raw data rather than using render tool?

 

Thanks,

Sarath.

binuacs
21 - Polaris

@Sarath27 Try this one

image.png

Sarath27
8 - Asteroid

@binuacs Both the files have different columns, still union tool will work on this?

binuacs
21 - Polaris

@Sarath27 yes, because we are giving the tab name separate it should work

Sarath27
8 - Asteroid

@binuacs Sorry to ask you again. I can see columns are mis-placed. Should we use block until done and if so where can I use it in the workflow?

Labels