We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Dynamic output with three tables in one tab

DannisMen
8 - Asteroid

Hi all, 

 

I have a problem of dynamic output.  I want each 'study_sid' to be its own Excel 'FILE' and within the file, each plcy_nbr to be its own tab. Each tab i want to have three tables separately. I know how to do this for one table each tab but struggles for three tables. The sample input has 2 study id and 2 plcy_nbr each id. So it should be 2 excel files and 2 tabs each file and three tables each tab. Ideally it will be just a matter of one dynamic output tool. But i'm not sure how can i put three tables together. 

 

Any idea?

 

Thanks

8 REPLIES 8
smoskowitz
12 - Quasar

Hi @DannisMen --

 

Have you look at the bottom of the output tool? There is an option to choose which column represents data in a particular tab. Please let me know if this helps!

 

smoskowitz_0-1605292900737.png

Seth

DannisMen
8 - Asteroid

That's what i did when there was only one table. But if it's three tables, i cannot use this method any more. Did you see my wf yet?

smoskowitz
12 - Quasar

Have you considered doing this via a macro -- where the Study_SID is the filter? Feed in each Study_sid and output? Let me know. In a meeting so cannot review at the moment, but I can certainly look at later. 🙂

 

Thanks,

Seth

DannisMen
8 - Asteroid

I could but then the user will have to do run by each study ID. There will be a lot.... But i can wait when you check it later! Thank you!

smoskowitz
12 - Quasar

Not necessarily,....if you create a batch macro and feed in a unique set of Sudy_Sid into a filter tool....the data would then run its course downstream. Take a look at batch macro's if that helps. Please let me know.

 

Seth

smoskowitz
12 - Quasar

Hi @DannisMen --

 

I will have a look at this over the weekend. Work emergencies are taking up my fun Alteryx time.

 

Thanks,

Seth

DannisMen
8 - Asteroid

Thanks for this! I'm still a bit confused on why would i use a batch macro anyways? The output tool should do it with a dynamic path. 

DannisMen
8 - Asteroid

Attached is how this works with one table per tab by creating a dynamic path. The only problem i had so far is i cannot do this on three tables per tab. It's gonna overwrite. 

 

DannisMen_1-1605402167414.png

 

 

Labels
Top Solution Authors