combine multiple sheets

[luo]

Hi Guys,

I am trying to combine multiple sheets together but failed. I try the method from https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Input-Multiple-Excel-sheets-with-a-...

I got very funny output like I cannot combine different sheet in the order of sheet. It will have null value and in the order of another column. 

I have upload the input. 

Thanks Guys.

[Jean-Balteryx · Accepted solution]

Hi @luo ,

I attached an example workflow reading dynamically all the sheets in your file. Tell me if the workflow does what you want or not.

Cheers,

Jean-Baptiste