How to merge multiple '.xlsx' files, diff schema ,and only 1 sheet from a folder

[AnkitDwivedi6]

How to merge multiple '.xlsx' files with different schema within a folder with only 1 of 3 sheets? I tried using “*” but showing error “ different schema”. 

[Qiu]

@AnkitDwivedi6 

Maybe this can help.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamic-Input-Different-Schema/td-p/65...

[MichalM]

@AnkitDwivedi6 

I'd also check Method #3 in the below article which is a great introduction to dynamic input of data in Alteryx

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...