Dynamic output with three tables in one tab

[DannisMen]

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

[smoskowitz]

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!

Seth

[DannisMen]

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]

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]

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]

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]

Hi @DannisMen --

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

Thanks,

Seth

[DannisMen]

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]

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.