Multiple sheet in single output

Question

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 !

Jay-RDC · Answer

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

unknown · Answer

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

Jay-RDC · Answer

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.