Different tables to different sheets in one file, based on sheetname

Question

Hi,

i need to output different tables with different structures,  to different tabs in one .xlsx file. Both sample tables are attached. The last field in each table is the intended sheet name.

I want to output that into a file, which the path is dynamic.

I was trying with the Output tool with no  results, also reading other posts on this topic, although, none worked, as render tools and layouts don't have a dynamic file path option and i don't want to see it in a browser view, i just need to send it to a file, which the path is dynamic with the tab names.

Thank you so much,
J

t2.yxdb

t1.yxdb

jcardoso · Answer

@atcodedog05 your method of changing versions really worked! Already shared among fellow colleagues! Appreciated!

@Qiu your macro works on the assumption that the .yxdb tables are stored somewhere as a physical file, in my case, those .yxdb files they are tables as an input end result from a bigger workflow. So the input of the macro should be the table directly, not the file containing the table.

Is there any workaround to this?

Regards,

Is there any workaroun

atcodedog05 · Answer

Hi @jcardoso

You can use this guide to downgrade the packaged workflow https://community.alteryx.com/t5/Engine-Works/Making-Workflows-Apps-amp-Macros-Backwards-Compatible/ba-p/779546

Hope this helps 🙂

Qiu · Answer

@jcardoso

Here you go.

New Workflow1.yxmd

yd.yxmc

t1.yxdb