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

Question

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”.

MichalM · Answer

@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/ta-p/20480

Qiu · Answer

@AnkitDwivedi6

Maybe this can help.

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