Dynamic output with three tables in one tab

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

Test kc2f.yxzp

Test KC2f.xlsx

Dynamic Processing

Accepted answers

All comments

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

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703