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

File output poser for you

Bigmonki
8 - Asteroid

Hi Everyone,

 

My challenge is splitting the data I have as an output into tabs by country and then appending the file with the date the workflow was run!

 

I know how to split to tabs using the 'Take File / Table Name from Field' option so each country gets its own tab within the workbook, I have also used the formula tool to create a 'date run' output to change the entire file path so it creates the workbook with the date run.

 

My question, is it possible to have both and create the sheets dynamically? Currently, I am having to create a separate output tool for each sheet and if a new country provides data, it isn't dynamic. Any ideas?

 

Bigmonki_0-1627479285136.png

 

Bigmonki_1-1627479325724.png

 

 

 

5 REPLIES 5
JagdeeshN
12 - Quasar
12 - Quasar

Hi @Bigmonki ,

 

Have you tried implementing the file creating logic in the form of a Batch Macro.

 

With that you can create one file at a time dynamically regardless of the number of countries.

 

Please find the link below on how to create and use a batch macro.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Getting-Started-with-Batch-Macros/t...

 

Hope that helps.

 

Best,

Jagdeesh

HomesickSurfer
12 - Quasar

Hi @Bigmonki 

 

This works.  Please 'Like' and 'Accept as Solution' if you agree.

 

Use the layout with section breaks and render out.

DateTimeStart() is ideal

 

Capture.PNG

 

Maskell_Rascal
13 - Pulsar

Hi @Bigmonki 

 

You were really close with your initial workflow. 

 

Just modify your formula to include Country as the Sheet Name:

Maskell_Rascal_0-1627481690452.png

 

Then setup your Output tool the same way you had it. 

 

Maskell_Rascal_1-1627481757878.png

 

This will dynamically add tabs to the file as new countries appear. 

 

The solution @HomesickSurfer provided works as well utilizing the reporting tools. But I wouldn't use reporting tools to solve for this output, since we can get the same results within one tool. Unless of course you want to provide some sort of formatting. 

 

Cheers!

Phil

HomesickSurfer
12 - Quasar

Thank you @Maskell_Rascal for the mention and attesting to the viability of my proposed solution.  I felt that given the output is 'User compliance' the output would be a report (with formatting, possible headers/footers, etc.) opposed to static data for other purposes, hence the use of reporting tools.  I do like minimal tool solution though!

Bigmonki
8 - Asteroid

Thanks everyone, some great solutions and shows there are many ways to solve a problem. Not sure with Batch macros, I would have to play some more!

 

@HomesickSurfer I like your solution and it has helped in understanding a little more about reporting tools which I have steered clear of until now. This has helped me with other challenges so for that I am very grateful.

 

@Maskell_Rascal simple, it is the quickest and easiest way to solve my immediate solution, thanks. 

Labels