Input Different Schema files without using macro

[Sneha_Lonkar]

Hello all,

Is there a way out to input multiple different schema excel files without using a macro? I heard about Interface option but not sure how to go about it. Can someone please help?

Regards,

Sneha

[BenMoss]

No there is not, may I ask why you don't want to use a macro?

Ben

[Sebastiaandb]

This might help you, haven't tested it myself tough: 

The Ultimate Input Data Flowchart - Alteryx Community entrée de données eingabedaten

Greetings,

Sebastiaan

[Sneha_Lonkar]

Hey Ben,

My firm has lots of governance/control structure in using a macro hence trying to find an alternative to avoid those scenarios. Also using Batch macro has solved my file schema issues but initially faced lots of errors while getting it to work right! One more reason is just curiosity 🙂