Multiple sheet in single output

[Inactive User]

Hi @All

How can we combine multiple sheet(sheet1,sheet2,........sheetn) to single output with multiple tabs using single output tool. And vice versa for input tool as well .

Can anyone help ?

Thanks in advance !

[Watermark]

 

Use and input tool, check the 'export sheet names' then use dynamic input tool. 

 

See attached. 

[Jay-RDC]

Hello. You can use the dynamic input if all the sheets has the same schema. If not, then you will have to use a macro.

[Inactive User]

@Jay-RDC How can we create macro for sheets having different schema ?

[Jay-RDC]

try this link: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamic-Input-Different-Schema/m-p/654...